Cumulative Total over a measure, using relationship

[Anonymous]

Hello,

I need cumulative sum of SalesAM table  and OrderAM table.

OrderAM table use relationship from Calendar[Date] to Sheet1[OrderDate]

SalesAM table use relationship from Calendar[Date] to Sheet1[SalesDate]

I am not able to figure out cumulative sum of those. Please help me out.

In below link you will find the link to pbix file.

Sales Data PBIX

Sale Data PBIX file

[tex628 · Accepted solution]

Try: 

Measure = 
VAR mdate = Max('Calendar'[Date])
Return
Calculate(
Sum( 'Sheet1'[OrderAM] ) ;
All('Calendar');
'Calendar'[Date] <=mdate
)

Do the same where you replace OrderAM with SalesAM in a new measure.

[Anonymous]

Thats was helpful, thanks