Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Backlog from Excel into DAX/Power BI

Hey, Hopeing to convert this Data from how it is stored into DAX/Power BI. I can't work out how to get the backlog information to work, Here is the excel formula. This is for the Monday =IFER...
Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , You have to take approach of onhand inventory to build cumulative and running total example

 

Inventory / OnHand
[Intial Inventory] + CALCULATE(SUM(Table[Ordered]),filter(date,date[date] <=maxx(date,date[date]))) - CALCULATE(SUM(Table[Sold]),filter(date,date[date] <=maxx(date,date[date])))

Inventory / OnHand
CALCULATE(firstnonblankvalue('Date'[Month]),sum(Table[Intial Inventory]),all('Date')) + CALCULATE(SUM(Table[Ordered]),filter(date,date[date] <=maxx(date,date[date]))) - CALCULATE(SUM(Table[Sold]),filter(date,date[date] <=maxx(date,date[date])))

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.