Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi guys,
Struggeling with a running total. I only want a running total if slicer selection is the same as a column in my table.
For example:
Slicer = FISCALYEAR
Then I only want a running total of all values/fiscalyears where column DP_YEAR is the same als the slicer(FISCALYEAR).
ASSETTRANS | FISCALYEAR | ASSET_ID | AMOUNT | DP_YEAR |
CAP | 2020 | 11287 | -6799111 | 2020 |
ADD | 2020 | 11293 | -13081,7 | 2021 |
ADD | 2021 | 11293 | -1774,94 | 2021 |
ADD | 2020 | 11293 | -197763 | 2021 |
ADD | 2020 | 11293 | -1234,77 | 2021 |
ADD | 2020 | 11293 | -593,94 | 2021 |
ADD | 2020 | 11293 | -35532,5 | 2021 |
ADD | 2020 | 11293 | -5493,17 | 2021 |
CAP | 2020 | 11287 | 20059,29 | 2020 |
CAP | 2020 | 11287 | -40118,6 | 2020 |
CAP | 2020 | 11287 | -19418 | 2020 |
CAP | 2020 | 11287 | -49582,9 | 2020 |
CAP | 2020 | 11287 | -52732 | 2020 |
CAP | 2020 | 11287 | -94165 | 2020 |
CAP | 2020 | 11287 | -74781 | 2020 |
CAP | 2020 | 11287 | -14009,2 | 2020 |
CAP | 2020 | 11287 | -168717 | 2020 |
CAP | 2020 | 11287 | -145684 | 2020 |
CAP | 2020 | 11287 | -399640 | 2020 |
CAP | 2020 | 11287 | -353831 | 2020 |
CAP | 2021 | 11293 | -53992,3 | 2021 |
ASSET_ID 11287 returns IF slicer FISCALYEAR = 2020
-8191731 |
and when FISCALYEAR = 2021 then 0
ASSET_ID 11293 returns IF slicer FISCALYEAR = 2020
0
and when FISCALYEAR = 2021 then
-309466 |
Thank you for you help.
Solved! Go to Solution.
Running total needs something that it can sort by. it is not clear from your data which column is suitable for sorting. Please elaborate.
User | Count |
---|---|
14 | |
9 | |
7 | |
7 | |
6 |
User | Count |
---|---|
22 | |
11 | |
10 | |
10 | |
8 |