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've check relationship everything but do not get what makes it wrong. I want the cumulative total for each month but this only shows the final number:
Hope anyone could clarify my confusion. Thank you
Solved! Go to Solution.
Thanks guys. I don't really know why it does not work. But I have an alternative way. Instead of using FILTER (ALL ( ... ) etc, I will use DATESYTD like this
Thanks guys. I don't really know why it does not work. But I have an alternative way. Instead of using FILTER (ALL ( ... ) etc, I will use DATESYTD like this
@yennhi95zz , I created my own sample to calculate running total and it's working fine.
@yennhi95zz , have tried water wall visual for that
one way is
M1= SUM(Sales[Sales Amount])
M2 = CALCULATE([M1],filter(allselected(date),date[date] <=eomonth(max(date[Date]),-1) ))//means cumm till last month
Now if you plot these two and make m2 as white you will reach till last month
Or use M3 in place of M1
M3 =
var _max = maxx(allselected('Date') ,'Date' [Date]))
return
if( max('Date' [Date]) = _max, CALCULATE([M1],filter(allselected(date),date[date] <=max(date[Date]))) , [M1] )
Cumm on M1 in last month
M4 =
var _max = maxx(allselected('Date') ,'Date' [Date]))
return
if( max('Date' [Date]) = _max, blank(), [M2])
use M3 and M4 in visual with m4 as white and try
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 |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |