As of right now there are YTD and MTD functions, as well as a DAX function which computes a running total for all time, but we are looking for a means of calculating a running total for a declared date range. That is to say, this would be a solution if we wanted to see what the running total was for June of the previous year to April of the current year.
4 Comments
- As of right now there are YTD and MTD functions, as well as a DAX function which computes a running total for all time, but we are looking for a means of calculating a running total for a declared date range. That is to say, this would be a solution if we wanted to see what the running total was for June of the previous year to April of the current year.
- As of right now there are YTD and MTD functions, as well as a DAX function which computes a running total for all time, but we are looking for a means of calculating a running total for a declared date range. That is to say, this would be a solution if we wanted to see what the running total was for June of the previous year to April of the current year.
- I've created a proposal to add ordered iterators to DAX, which should make it much easier to create/use running totals. I think it could work well for your use case. https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/40647124-ordered-iterators
- Status added:Needs Votes
