Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
yennhi95zz
Frequent Visitor

Cumulative Total only shows the last number

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:

 

yennhi95zz_0-1628578570600.png

 

yennhi95zz_1-1628578617479.png

 

Hope anyone could clarify my confusion. Thank you

1 ACCEPTED SOLUTION
yennhi95zz
Frequent Visitor

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_0-1628597709065.png

 

View solution in original post

3 REPLIES 3
yennhi95zz
Frequent Visitor

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_0-1628597709065.png

 

Tahreem24
Super User
Super User

@yennhi95zz , I created my own sample to calculate running total and it's working fine.

Capture.JPG

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard
amitchandak
Super User
Super User

@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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.