Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have two columns
Value | Total |
10 | 600 |
20 | 600 |
40 | 600 |
30 | 600 |
10 | 600 |
80 | 600 |
20 | 600 |
40 | 600 |
Expected output is
Output |
590 |
570 |
530 |
500 |
490 |
410 |
390 |
350 |
Please suggest a DAX formula to perform this action.
Thanks in advance.
Solved! Go to Solution.
1. From your table display choose Edit Query
2. When the Query Editor Opens up choose AddColumn tab and Index Column from 0
3. Create RunTot columns as
RunTot = CALCULATE(sum(Table1[Value]), FIlter(Table1,Table1[Index]<=EARLIER(Table1[Index])))
( replace Table1 by the name of your table )
4. Create another column Final
Final = [Total]-[RunTot]
5. Plot the values in a Table Chart and you will get the desired output.
If this works for you please accept this as a solution and also give KUDOS.
Cheers
CheenuSing
1. From your table display choose Edit Query
2. When the Query Editor Opens up choose AddColumn tab and Index Column from 0
3. Create RunTot columns as
RunTot = CALCULATE(sum(Table1[Value]), FIlter(Table1,Table1[Index]<=EARLIER(Table1[Index])))
( replace Table1 by the name of your table )
4. Create another column Final
Final = [Total]-[RunTot]
5. Plot the values in a Table Chart and you will get the desired output.
If this works for you please accept this as a solution and also give KUDOS.
Cheers
CheenuSing
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |