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.
Hi, sorry for my english, i'm french.
I have a table like this and i would calculate the column "Montant cumulé". So, for each Month, the cumulative amount per Month and per N°Contrat.. Can you help me to found the DAX formule for the yellow Column plesae ?
Thanks for helping.
Solved! Go to Solution.
[Montant cumule] = var __noContrat = selectedvalue ( T[N°Contrat] ) var __currentDate = max ( T[Date] ) var __cumule = SUMX( FILTER( ALL ( T ), T[N°Contrat] = __noContrat && T[Date] <= __currentDate ), T[Montant] ) return __cumule
[Montant cumule] = var __noContrat = T[N°Contrat] var __currentDate = T[Date] var __cumule = SUMX( FILTER( T, T[N°Contrat] = __noContrat && T[Date] <= __currentDate ), T[Montant] ) return __cumule
Hi, thanks
but i have another dufficult, i have try your solution but when i have more amount in the same month with négative value, it's no good.
For exemple, with this table :
I must have for N°Contrat C002 a cumulative value of 130.
But with your formule, i have 260 :
Thank you very much for your help.
[Montant cumule] = var __noContrat = selectedvalue ( T[N°Contrat] ) var __currentDate = max ( T[Date] ) var __cumule = SUMX( FILTER( ALL ( T ), T[N°Contrat] = __noContrat && T[Date] <= __currentDate ), T[Montant] ) return __cumule
It's ok !!!
Thanks for your help !
I'm sorry.
Can you help me ?
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |