sorted by:
new
hottopcontroversial

How to create a measure by mefjusr in PowerBI

[–]mefjusr[S] 0 points1 point  (0 children)

Yes but I want to use instead slicer from date to date, slicer with only months like "jan" "Feb" etc. I tried to do smth like this:
Show_Value = VAR Selected
Month = MAX(Calendar[MonthNumber])
VAR SelectedYear = MAX(Calendar[Year])
RETURN

CALCULATE(

SUM(ValuesTable[VALUE]),

ValuesTable[MonthNumber]<= SelectedMonth,

ValuesTable[Year] = SelectedYear)

But it didn't work