Forum Discussion
TimmK
Helper IV
Helper IVIncome Statement Matrix Percentage
For the income statement I want to create a matrix table: Rows: Different categories (revenue, different types of expenses) Columns: Years (2021, 2020, 2019 etc.) Values: Amount (and percentage) ...
VahidDM
Super User
Super UserHi TimmK
Try this measure:
% =
VAR _2021 =
CALCULATE (
SUM ( 'Table'[Amount] ),
ALLEXCEPT ( 'Table', 'Table'[Category] ),
'Table'[Year] = 2021
)
RETURN
_2021 / SUM ( 'Table'[Amount] )
Output:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
