Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Income 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) ...
Help Requested
VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
5 years ago

Hi Anonymous 

 

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!!

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi VahidDM 

     

    Thank you for your great and helpful answer.

     

    Yet, I actually have three tables that result in the income statement, namely the date, account and income table. How can I apply ALLEXCEPT here?