Forum Discussion

Manar's avatar
Manar
Helper II
8 years ago
Solved

Difference between 2 columns in Matrix

Hi, I have the following Matrix and I would like to add another column with the difference between the rates of the 2 different periods columns (201803 & 201802), these 2 columns are from the same co...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    HI Manar

     

    Try this one

     

    Measure =
CALCULATE (
    SUM ( ExchangeRatesFacts[ExchangeRate] ),
    FILTER (
        ALL ( ExchangeRatesFacts[ReportingPeriod] ),
        ExchangeRatesFacts[ReportingPeriod] = [CurrentReportingPeriod]
    )
)
    - CALCULATE (
        SUM ( ExchangeRatesFacts[ExchangeRate] ),
        FILTER (
            ALL ( ExchangeRatesFacts[ReportingPeriod] ),
            ExchangeRatesFacts[ReportingPeriod] = [LastReportingPeriod]
        )
    )
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

HI Manar

 

Try a MEASURE along following lines

 

Measure =
CALCULATE ( SUM ( TableName[Rates] ), TableName[ReportingPeriod] = 201803 )
    - CALCULATE ( SUM ( TableName[Rates] ), TableName[ReportingPeriod] = 201802 )
Anonymous's avatar
Anonymous
Not applicable
4 years ago

What about if we have year more than 2 like 2015 , 2016 ,2017 ,2018 , 2019, 2020