Forum Discussion

AlexGallet01's avatar
AlexGallet01
Helper IV
9 years ago

PB Calcul

Mesure = CALCULATE(SUM(LCOMCLI[Objectif Commande]);FILTER(ALL(LCOMCLI);LCOMCLI[Jour Creation commande].[Date] >= DATE(2016;07;01) && LCOMCLI[Jour Creation commande].[Date] <= DATE(2017;06;31)))

 

I want to take the max value of month for calculate my sum and together with my calculate cumulatif. Have you got an idee for resolv this.

Need Help

2 Replies

  • AlexGallet01's avatar
    AlexGallet01
    Helper IV
    9 years ago

    j'ai un problème j'aimerais faire un cumul de mes max objectif commande mais je ne sais pas comment m'y prendre car dans ma base de données chaque commande à l'objectif final du mois donc lorsque je fait un cumul sa me cumul d'objectif final qui est donc faux car j'aimerais avoir qu'une seule fois l'objectif final et non le cumulé je veux juste faire le cumul sur tous les mois de l'année.

     

    I have a problem I would like to accumulate my max objective command but I do not know how to do it because in my database every command to the end goal of the month so when I do a cumulative its cumulative Of final objective which is therefore false because I would like to have only once the final objective and not the cumulative I just want to accumulate on all the months of the year.

     

     

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      9 years ago

      Hi AlexGallet01,

       

      Could you please post sample data and expected result for further analysis? You can using the following formula to calculate the cumulative total.

       

      cumulative = CALCULATE(SUM(Sales[SALE]),FILTER(ALL(Sales),Sales[DATE]<=MAX(Sales[DATE])))


      Best Regards,
      Angelia