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

 

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