Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I have table with Date, Customers, Value, and what I need is to get diffrence of Value from previous month.
To get the value from previous month I was trying create Measure like that:
last month value = CALCULATE(sum(Table1[Value]),PREVIOUSMONTH(Table1[Date].[Date]))
But it's not working for me.
I have test measure liek these:
Total Value = sum(Table1[Value])
and these:
previous Month = PREVIOUSMONTH(Table1[Date])
And the last two measures are working for me, the last one it's returnign date with month before - which is correct, but as soon as I'll put them togather in to calculaton formula, I'm getting nothing, blank table with not data.
Waht I'm doing wrong?
Solved! Go to Solution.
You can create a calendar table with DAX and make relationship between the CalendarTable and Table1, then drag the measure into Table visual to see the results.
Best Regards,
Herbert
You can create a calendar table with DAX and make relationship between the CalendarTable and Table1, then drag the measure into Table visual to see the results.
Best Regards,
Herbert
Great, that works for me!
Thanks a lot.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
89 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |