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
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
View solution in original post
@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
var _max = maxx(allselected('Date') ,'Date' [Date]))
if( max('Date' [Date]) = _max, CALCULATE([M1],filter(allselected(date),date[date] <=max(date[Date]))) , [M1] )
Cumm on M1 in last month
if( max('Date' [Date]) = _max, blank(), [M2])
use M3 and M4 in visual with m4 as white and try
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.