Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Hello,
Maybe this will help:
YourMeasure =
VAR LastDayPrevMonth = EOMONTH(TODAY(), -1)
RETURN
TOTALYTD(
[YourExpression],
Data[Date],
LastDayPrevMonth
)
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
34 | |
14 | |
12 | |
12 | |
11 |