Forum Discussion
SUMMARIZE Not Returning Correct Sum Value
Hello, I'm trying to perform a SUM of the Production Qty at the Scheduled Shift level which is the next level of granularity from MATERIAL_NUMBER but I'm not getting the correct summation. I perf...
Using the "Group By" functionality in Power Query Editor worked for me. I followed the instructions near the bottom of this article link...Link
You DAX proposal includes ALLEXCEPT() which will inflate my records. Unfortunately, this method won't work. I'm going to try the "Group By" functionality within the Power Query Editor and see if that gives me the desired results. I appreciate your efforts in trying to find a solution here!
Using the "Group By" functionality in Power Query Editor worked for me. I followed the instructions near the bottom of this article link...Link