Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
98 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |