Forum Discussion

Mattiar's avatar
Mattiar
Icon for Resolver I rankResolver I
2 years ago

Variables in TotalYTD [,YearEndDate]

Hello, everyone, I'm submitting a problem to you and ask if you have any workarounds.   I was simply doing a YTD and wanted it to end at the previous month. I get the result by putting the month v...
MalkhazTsagarel's avatar
MalkhazTsagarel
Regular Visitor
2 years ago

Hello, 
Maybe this will help:
YourMeasure =
VAR LastDayPrevMonth = EOMONTH(TODAY(), -1)
RETURN
TOTALYTD(
[YourExpression],
Data[Date],
LastDayPrevMonth
)

  • Mattiar's avatar
    Mattiar
    Icon for Resolver I rankResolver I
    2 years ago

    As I wrote above, the problem is precisely that the measure currently does not accept a variable as input even if it is a constant.