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 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 🙂
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |