Matrix with Measures for Two columns

[Sashwato]

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!

[Anonymous]

Hi @Sashwato ,

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

[Arul]

Hi @Sashwato ,

Could you share any sample data and the measures used?

Thanks,

-Arul