Struggeling with a running total. I only want a running total if slicer selection is the same as a column in my table.
Slicer = FISCALYEAR
Then I only want a running total of all values/fiscalyears where column DP_YEAR is the same als the slicer(FISCALYEAR).
ASSET_ID 11287 returns IF slicer FISCALYEAR = 2020
and when FISCALYEAR = 2021 then 0
ASSET_ID 11293 returns IF slicer FISCALYEAR = 2020
and when FISCALYEAR = 2021 then
Thank you for you help.
Go to Solution.
View solution in original post
Running total needs something that it can sort by. it is not clear from your data which column is suitable for sorting. Please elaborate.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.