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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Rabelo
New Contributor II

How calculate difference of columns in MATRIX visual, between 2 months not in sequence ?

Hi ... there is always a new challange in PBI, isn't !?๐Ÿ˜…๐Ÿ˜…

 

Here we go ... see this simple matrix:

Rabelo_0-1683919561661.png

1 - How could be calculated the difference of sales between those two filtered months (not sequenced), for each product item ?

2 - How could be displayed that last column DIFFERENCE ?

Thanks all ... a lot !!!

 

1 REPLY 1
mrcss23
New Contributor III

Hi @Rabelo see a suggestion in here https://www.youtube.com/watch?v=UnCi0XUYDOc

Should create a DAX to CALCULATE the difference

 

Helpful resources

Announcements
Users online (3,085)