Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Matrix with Measures for Two columns

Hello all,

 

I am trying to create a solution in a matrix/table format. Please refer screenshot below:

 

Do we need to use any kind of Summarize Table function or something? Please note that all the values for Current month and Prior month are measures calculated on the table.

Any help is appreciated!

Regards!

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

  • Arul's avatar
    Arul
    Super User
    5 years ago

    Hi Anonymous ,

     

    Could you share any sample data and the measures used?

     

    Thanks,

    -Arul

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

    Based on the data in your screenshot, one of the differences between the table above and the table below is the display of negative values. The top table is represented by "-", while the bottom one is represented by "()". If you just want to handle negative values, you can create the following measure:

    New measure = FORMAT ( [your original measure], "##,###;(##,###);-" )

    Power BI: How to bracket negative numbers in a financial statement

    If my understanding is not correct, could you please provide more details to explain your requirement and your expected result. Also please provide the formula of measure [Current Month] and [Prior Month]. Thank you.

    Best Regards