Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a table - Data, with columns:
Year - Date type
Sales - Whole number
Cost - Whole number
I created a measure for Profit = Table[Sales] - Table[Cost]
How do i put the measure "Profit" in this following running total formula. It doesn't show the measure as an input on the Sum function:
Running Profit COLUMN = CALCULATE (
SUM ( 'Profit' ),
ALL ( 'Data' ),
'Data'[Year] <= EARLIER ( 'Data'[Year] ) )
Solved! Go to Solution.
Hi @spoony
This might be close to what you need, and it doesn't rely on your other measures.
Running Total Column = SUMX( FILTER( 'Table1', 'Table1'[Year]<=EARLIER('Table1'[Year]) ), 'Table1'[Sales]-'Table1'[Cost])
Hi @spoony
This might be close to what you need, and it doesn't rely on your other measures.
Running Total Column = SUMX( FILTER( 'Table1', 'Table1'[Year]<=EARLIER('Table1'[Year]) ), 'Table1'[Sales]-'Table1'[Cost])
Thanks phil, its kinda working. My filter on one of the columns of this table is causing it to not work so i have to look into.
ok, feel free to post back here if you need more help 🙂