Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |