Forum Discussion
Accumulate Surplus and Deficit
Hello, I have a table with transactions, each transaction has a "gap". The gap indicates either a surplus (positive gap) or a deficit (negative gap). I am trying to calculate the accumulated defici...
hmayol ,
Could you provide some sample data and the expected result, so that I can help you.
The information that you have provided is not clear. What is C3, E2 and D2. I think this are the cell references in the excel file.
Please provide sample data to understand your requirement.
Regards,
Pavan Vanguri.
Anonymous
I have two files here
- the pbix file has two columns
- customer_id-patient_id-GPI10-dispense_index: this column serves as a dispense index. Each customer_id-patient_id-GPI10 values has n dispenses. The accumulated deficit needs to be calculated per customer_id-patient_id-GPI10
- Refill_Gap_PDC: this is the column that identifies a surplus or deficit per dispense.
- The xlsx file is a sample calculation of what the final outcome should be in power bi with one customer_id-patient_id-GPI10 example.
Let me know if you need anymore information.
Thanks,
Hector M.