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 All,
I am new to DAX and have been trying to solve this problem for a few days now with no luck. I have found multiple forum posts with similar requests but none that solve my exact situation.
Any help would be much appreciated and thank you in advance!
I have the following table containing manufacturing information. An Order #, an Operation # within that Order #, and the Output Qty of that operation:
I would like to add a DAX calculated column that, for every row, displays the Output Qty of the final operation in the order:
I hope that makes sense. It seems like fairly straight forward logic to me but I just cannot come up with a DAX formula that works.
Solved! Go to Solution.
See if this works, I'm worried if you have other filters, they may impact the results...
Forrest
Proud to give back to the community!
Thank You!
See if this works, I'm worried if you have other filters, they may impact the results...
Forrest
Proud to give back to the community!
Thank You!
Hi, how would be the same formula but filling only the rows with the result in the corresponding rows? like this image
Works like a charm. Thank you for the quick response!
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 |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |