Forum Discussion
Solved
Dynamic running totals based on Financial year filter selection
Hi All, I am working on a requirement where if a financial year is selected the Values less than equal to selected FY should sum up for all distinct categories . For Example : RowNo Category...
OK, now I got it
see attached.
Do you mean running totals or simple sums? What would the expected outcome look like for your two scenarios?
- HI lbendlin , it's only the running total . If FY 2023-24 is selected in filter I should get sum of row nos. 1,2 and 4 so the total is 1100.
- If the FY 2022-23 is selected in the filter row nos 2,3,4 needs to sum up hence the total is 900
You get that for free in the UI, no code required. Give it a try.
I tried DAX and I am able to get the running total for all FYs but I am unable to filter out the condition which I have mentioned.