Variables in TotalYTD [,YearEndDate]

[Mattiar]

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 value as a string.

Since a static value is required, I tried initialising a variable that would get the desired.

As I show you from the pictures, this is currently not possible.

Do you have another way?

Mattia

[MalkhazTsagarel]

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

[Mattiar]

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.