Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
FilipaPereira
Frequent Visitor

Matrix with variation calculation for one period only

FilipaPereira_1-1750094876404.png

I needed to build a matrix like this, in which I have a three-month view of the last two years and in which I only have the variation calculated for the last month.
How do I do this and power bi?
Can anyone help?

1 REPLY 1
v-kpoloju-msft
Community Support
Community Support

Hi @FilipaPereira,
Thank you for reaching out to the Microsoft fabric community forum. 

I reproduced the scenario, and it worked on my end. I used it as sample data and successfully implemented it.

vkpolojumsft_0-1750148867245.png

 



vkpolojumsft_1-1750148867246.png


I am also including .pbix file for your better understanding, please have a look into it:

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.