Calculate cumulative difference total

Question

Hi,I need to create a measure (called "Inventory") to calculate in power BI the following formula as you see in Excel :Inventory =&nbsp;Last period Inventory + Revenue - Billings&nbsp;I have the categories "Billings" and "Revenue" in the same column (Category Group).&nbsp;Any Ideas ?Thanks and regards,&nbsp;&nbsp;&nbsp;&nbsp;

v-chuncz-msft · Answer

cristianml&nbsp;,
&nbsp;
You may take a look at the post below.
https://community.powerbi.com/t5/Desktop/Accumulative-values-from-a-count/td-p/284229

cristianml · Answer

Hi&nbsp;v-chuncz-msft&nbsp;,&nbsp;Is not the same Solution. In this case I have to calculate a difference and then acumulate it with previous period. Follow the screenshot:Thanks,&nbsp;

Forum Discussion

Calculate cumulative difference total

2 Replies

Related content

Cumulative Difference from Another measure

Cumulative Total

Dynamic Calculation Different Period

Different Calculations

calculate cumulative sales for active products