Dynamic calculated column in Matrix Table

hasarinfareeth you can easily use time intelligence function to compare current month value with the previous month. There are many time intelligence videos/posts on how to get previous month data. Once you have that calculation in place than you can use conditional formatting to show arrows.

As a best practice, add a date dimension in your model and use it for time intelligence calculations. Once the date dimension is added, mark it as a date table on table tools. Check the related videos on my YT channel

Add Date Dimension
Importance of Date Dimension
Mark date dimension as a date table - why and how?
Time Intelligence Playlist

Hello hasarinfareeth ,

For your case, the field parameter solution is suitable. Please follow these steps:

1. Create the two required measures.
2. Open Power BI Desktop and navigate to the Modeling tab.
3. Click on 'New Parameter (Field)' and select the two measures you created.
4. Click 'OK' to automatically create a slicer.
5. Finally, add the column from the table generated by the field parameter to your matrix visualization.

Below are some links that explain how to implement field parameters in detail:
Ms Field parameter: target=_blank target=_blankhttps://community.fabric.microsoft.com/t5/Power-BI-Community-Blog/Field-Parameters-in-Power-BI/ba-p/2594308
One of my blog I mentioned field parameter detailly: target=_blank target=_blankhttps://medium.com/microsoft-power-bi/field-parameter-dynamic-title-change-3ba70a974152

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |