Cumulative Sum - Fiscal Year (Multiple Years)

Question

Hello,&nbsp;&nbsp;I need to create a measure to calculate the cumulative sum across Fiscal Years, and show all FY in a visual. I have 3 Fiscal Years in my data. However, all of the formulas I have tried only provide the cumulative sum for one Fiscal Year. I need the resulting measure to display with Cumulative or Running Total on the Y Axis, Month on the X Axis, and FY as the Legend.&nbsp;&nbsp;This is the current formula:Cumulative YTD = VAR MaxDate = MAX ( 'Date'[Date] )RETURN&nbsp; &nbsp; CALCULATE ( [SB Sales Sum] , &nbsp; &nbsp; FILTER( ALL( 'Date' ), 'Date'[Date] &lt;= MaxDate &amp;&amp; 'Date'[Fiscal Year] = MAX( 'Date'[Fiscal Year])))&nbsp;Also, the SB Sales Sum formula is as follows:SB Sales Sum =&nbsp;CALCULATE(SUM(Sales[Small Business]), Sales[Small Business] = 1)&nbsp;I have also tried the following formula, which results in the same issue:&nbsp;Cumulative Total SB = CALCULATE( SUMX( FILTER( Sales, Sales[Small Business] = 1), [SB Sales]), DATESYTD('Date'[Date], "30/9") )&nbsp;This is the current visual.&nbsp;&nbsp;&nbsp;This is a sample of my Date table&nbsp;The Date Table is connected to the Sales Table on the Sales Date Column.&nbsp;&nbsp;&nbsp;&nbsp;

greg_deckler · Accepted Answer

gobrien06&nbsp;You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008

Forum Discussion

Cumulative Sum - Fiscal Year (Multiple Years)

2 Replies

Related content

Cumulative Fiscal week DAX Calc

Cumulative Total

Cumulative total for fiscal year

Average not calculating cumulatively when selecting multiple months (quarter) or fiscal years

Cumulative Multiplication measure