I have two columns
Expected output is
Please suggest a DAX formula to perform this action.
Thanks in advance.
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.
View solution in original post
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!