Forum Discussion

JakeWestonD3's avatar
JakeWestonD3
Frequent Visitor
5 years ago

Cumulative (running) Total with specific date range

Hello community, My company uses irregular fiscal years. They never start or end on the same day each year and they are not always the same amount of days. I want to do cumulative (running) totals...
Need Help
v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

Hi JakeWestonD3 ,

 

Is your issue solved now？

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

  • JakeWestonD3's avatar
    JakeWestonD3
    Frequent Visitor
    5 years ago

    Hey v-kelly-msft I do have my date table set up and identified as a date table. The meausre from your post works for the cumulative total calculation and I can make other measures that isolate the years for comparison. The problem is that i need the cumulatives to start over each fiscal year. The "DATESYTD" accomplishes this but it does not start the cumulatives over based on my fiscal years, it does it based on the actual change of the year (December 31st).

    • v-kelly-msft's avatar
      v-kelly-msft
      Community Support
      5 years ago

      Hi JakeWestonD3 ,

       

      Could you pls provide some sample data with expected output for test?

       

      Best Regards,
      Kelly

      Did I answer your question? Mark my post as a solution!