Forum Discussion

Willborn's avatar
Willborn
Advocate III
10 years ago

Measure increase/decrease of quote deliveries by month/s in %

Dear Colleagues   I need to do a POC till Monday, showing the deviation of quotes sent to the customer. What I did so far is to join the tables from SAP containing the quote “created date/time” an...
Need Help
Sean's avatar
Sean
Community Champion
10 years ago

Willborn

You obviously need a COUNTing measure instead of SUM for these formulas but this should help you for the

MoM (Month on Month Calculations) MoM and MoM %

 

Let me know if you got it to work...

Willborn's avatar
Willborn
Advocate III
10 years ago

Hi Sean

 

Didn't had success so far. I'll tried AVERAGE and SUM, but both gives me error message that only 1 Argument can be used.

The Date Column contains dates from April '16, March'16, Febraury '16 etc. - I'll need to calculate Delta in % of March and February.

 

So far I did

Measure = CALCULATE(1-(SUM('ZETA Order BCS BCAG'[DurationDays]) / (SUM('ZETA Order BCS BCAG'[DurationDays]))))

but I cant get out how to implement the two month into this formula...

 

 

Regards Patrick

  • Willborn's avatar
    Willborn
    Advocate III
    10 years ago

    Finally tried with the following, but also here, the error is "too many arguments passed for the SUM function":

     

    Measure = CALCULATE(1- (SUM ('ZETA Order BCS BCAG'[DurationDays];PREVIOUSMONTH('ZETA Order BCS BCAG'[Date])) / SUM('ZETA Order BCS BCAG'[DurationDays];PARALLELPERIOD('ZETA Order BCS BCAG'[Date];-1;month)) ))

    When I have dates of April, the function "PREVIOUSMONTH" shall return the SUM of the values in [DurationDays] of the Month "March" within the Column [Date], and "PARALLELPERIOD" -1 this from February -  is this correct?

     

     

     

    Regards from confused and screwed up Patrick

  • Sean's avatar
    Sean
    Community Champion
    10 years ago

    Willborn How do you calculate these? Do they represent different months?

    • Willborn's avatar
      Willborn
      Advocate III
      10 years ago

      Hi Sean

       

      From the one column where I have extracted the duration I did a simple count on the different values, according to the date filter i've setted (not very dynamic, but ok for the moment).

       

      • Willborn's avatar
        Willborn
        Advocate III
        10 years ago

        If I have the report level filter set to March '16 - does this also influence the metric? If this is the case, I will have just another problem...