Forum Discussion
Dynamically subtracting values in rows
I am not sure the best way to articulate my need, but I have a data set that looks similar to the below: Key Item ID Expiration Qty On Hand 19384 123456 7/24/2024 100 174...
The expected output is listed above in the initial post. I would not be able to use SUMMARIZE or any DAX expressions as this does need to be done in PowerQuery, so that it can live in the Dataflow. If done at the report level it would have to be done hundreds of times.