Forum Discussion
Using a Multiplier to Construct Financial Statements
I am realitively new to Power BI. I am attempting to use a multiplier (negative if expense) to construct an income statement. It appears to work at the bottom level of the grouping, however the su...
This measure will not work like that. Use should use SUMX instead in this case.
But you can create calculated column in your table like this:
InvertedAmount$ = Financials[Multiplier] * Financials[Dollars]
And then you can create a measure like $ = SUM(Financials[InvertedAmount$])
Appreciate your Kudos !!!