Forum Discussion

visubabu24's avatar
visubabu24
Frequent Visitor
2 years ago
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...
DAX
visubabu24's avatar
visubabu24
Frequent Visitor
2 years ago

Here the blocker for me is in running total we should consider only the category of latest FY. 

  • for example If I am selecting 2023-24, Furniture category is already there in 2023-24 hence our calculation should ignore 2021-22, decors category already available in 2021_2022 hence calculation should  ignore decors in fy 2021-22
  • visubabu24's avatar
    visubabu24
    Frequent Visitor
    2 years ago

    Thank You So much Ibendlin .