Forum Discussion

cwnoll's avatar
cwnoll
Frequent Visitor
6 years ago
Solved

Help with MoM% change using date filter

I have a date filter on my dashboard, that is currently set at 1/1/2019(start) and 1/27/2020(end). I have a matrix with Mth-Yr in columns and data in each column. I am trying to calculate the % chang...
Need Help
  • cwnoll's avatar
    cwnoll
    6 years ago

    Thanks all for the quick responses, but I found a solution that works. I am using the following measure to accomplish this.

     

    Trans MoM Var =
    VAR __PREV_MONTH =
    CALCULATE([Transport MTD],DATEADD(FILTER(DATESMTD('Calendar'[Date]),'Calendar'[Date]<TODAY()),-1,MONTH))
    RETURN
        DIVIDE(SUM('TD'[Transport]) - __PREV_MONTH, __PREV_MONTH)
mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi cwnoll,

 

does it really matter?

I mean do you also consider working days?

Or how do you compare February 2019 (28 Days) to March 2019 (31 Days)?

 

Perhaps you could consider the percentage progress of the month. (27/31 = 87%)

 

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.