Forum Discussion

oren's avatar
oren
Helper III
8 years ago

Differences between 2 Matrix in Power BI

Hi i have 2 metrix that came from the same source  each metrix have diffrent data that change based on 2 diffrent filters i did (date filters) now i wand to create anothe metrix that show the difr...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi oren

 

You will not be able to compare 2 matrix as such. You need to have measures to do this.

 

For ex: you may have sum ( sales) in Matrix1. Matrix 2 with different date filter say fo ex 05/18/2018 in Matrix1 and 05/19/2018 in Matrix 2.

 

In your New matrix, you may need to like this:

 

Sales_diff = CALCULATE ( SUM(Sales), date="05/18/2018" )-CALCULATE ( SUM(Sales), date="05/19/2018" )

 

Hope this gives you the direction.

 

Thanks