Rolling Values of Backlog

[PowerBI__]

Hello,

I have 3 measures. 1st is the backlog initial value which is a static value. 2nd is Total revenue and 3rd is total expense
I want to calculate backlog and its formula would be
Backlog = Initial Backlog+Total Revenue-Total Expense
Backlog = 2000+1000-500=2500
I want if next month comes then the backlog I have created aboe will become initial backlog and that month revenue will be added along with that month expense would be subtracted so the formula will become
Backlog = Initial Backlog+Total Revenue-Total Expense
Backlog = 2500+3000-1500=4000
I want that backlog moves next month when next month comes in. 
Kindly help me get such formula that roll over back log with that month revenue and expense.
You help would be highly appreciated.
Thank you

[Ashish_Mathur · Accepted solution]

Hi,

I have answered your question here - Re: Rolling / cummulative Value of Backlog - Microsoft Fabric Community

[v-shex-msft]

Hi @PowerBI__,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng