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