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 difrences between the two tables

 

thanks a lot

 

oren 

Need Help

7 Replies

  • 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

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi Oren,

     

    Can you share a sample and the expected result, please?

     

    Best Regards,

    Dale

    • oren's avatar
      oren
      Helper III
      8 years ago

      hi again

       

      attached is an example
      what i need is a third Matrix with the diff between the 2 i have- as you can see the 2 matrix are change based on filter (each matrix have different filter)

       

      thanks a lot

       

      oren