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
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 

 

  • oren's avatar
    oren
    Helper III
    8 years ago

    anything ?

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

    Hi oren,

     

    You can try a single measure with "SAMEPERIODLASTYEAR" like below.

    Measure =
VAR thisyear =
    SUM ( FactSales[SalesQuantity] )
VAR lastyear =
    CALCULATE (
        SUM ( FactSales[SalesQuantity] ),
        SAMEPERIODLASTYEAR ( DimDate[Datekey] )
    )
RETURN
    thisyear - lastyear

    Best Regards,

    Dale

    • oren's avatar
      oren
      Helper III
      8 years ago

      Dhanks Dale

       

      as you seggested i put this dax -

       

      DiffDiscount =
      VAR thisyear =
      SUM ( 'DATA'[Discount] )
      VAR lastyear =
      CALCULATE (
      SUM ( 'DATA'[Discount] ),
      SAMEPERIODLASTYEAR ( 'Dateuniqe'[PriceLogDate] )
      )
      RETURN
      thisyear - lastyear

       

      but i just get the same data as in the "current Discount"

      (maybe i dont know waht to use in the "SAMEPERIODLASTYEAR ( 'Dateuniqe'[PriceLogDate] )" - i just took a uniq dates table (is it right?)

       

      attached is the data i got (the right table)

       

      thanks again

       

      oren 

      • oren's avatar
        oren
        Helper III
        8 years ago

        no option?