Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Profit & Loss DAX Help

Hi,

 

Below shows the Power BI Report I am working on.

I need to add some rows based calculations to the Profit & Loss - Last Month shown but keep the matrix layout.

Below shows the final result I am after. Any help writing the dax for this would be appreaciated.

Cheers

John

Need Help

1 Reply

  • dax's avatar
    dax
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi ozbroomy,

    It seems that you want to refer to previous calculated result and you want to add custom subtotal in Matrix, right?

    As I know, there is no custom subtotal setting for Matrix, you might need to create a column to define  a group like below, then it will show like a subtotal

    By the way, if possible, could you please inform me more detailed information (such as your sample data and your expecting output)? Then I will help you more correctly.

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.