Forum Discussion

Frequent Visitor

3 years ago

Solved

Cumulative Sum - Fiscal Year (Multiple Years)

Hello, 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 on...

Need Help

Greg_Deckler
3 years ago
gobrien06 You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, 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

Greg_Deckler

Community Champion

3 years ago

gobrien06 You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

Also, 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

gobrien06

Frequent Visitor

3 years ago

Thank you for the information. I was also having an issue due to a filter selection, but your formulas calculate what I need.

Forum Discussion

Cumulative Sum - Fiscal Year (Multiple Years)

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