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.
Im trying to divide the parcels of my products in line and tried to do something like this
the measure ReceivedValue running total... works fine with DocName that the parcels have the same value(A,C) but when there is a value different in the parcel(B,D) things don't work very well. Can someone help me with this?
This is what i expect
Thanks
Power Bi File
Solved! Go to Solution.
Hi @Anonymous ,
you can do it like this (take a look at the attached PBIX file):
Running Total =
CALCULATE (
[Sum of ReceivedValue],
FILTER (
ALLEXCEPT ( Planilha1, Planilha1[OrderId] ),
Planilha1[DatePayment] <= MAX ( Planilha1[DatePayment] )
)
)
Sum of ReceivedValue = SUM(Planilha1[ReceivedValue])
With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)
Hi @Anonymous ,
you can do it like this (take a look at the attached PBIX file):
Running Total =
CALCULATE (
[Sum of ReceivedValue],
FILTER (
ALLEXCEPT ( Planilha1, Planilha1[OrderId] ),
Planilha1[DatePayment] <= MAX ( Planilha1[DatePayment] )
)
)
Sum of ReceivedValue = SUM(Planilha1[ReceivedValue])
With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)
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 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |