Forum Discussion
Apply difference to multiple IDs within a group in DAX
I have a table with daily Consumption totals and a fixed Capacity amount per ID. I want the Consumption value to be subtracted from the "first" ID's Capacity until it is 0, and then subtract the rema...
kentyler
Solution Sage
Solution Sageany chance you can post a sample power bi file that i could look at...
File is Attached Below. I am looking to compute the running total of ID - running total Consumption and if that value is < 0, apply the leftover to the related ID within the Group. Either I would like to add a calculated column to the ID table, or create a measure in the matrix. Appreciate any ideas you would have.
Note: There are Consumption Rates for all Days. Also, the data in the file will not match the Excel table above. I just recreated my Query, calculated tables, and relationships in the sample PBI file to help visualize what I have already.