Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

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
=IFERROR(IF(IF(Date!B42<=TODAY()+3,AD41-G41-H41-F41+S41,"")>0,IF(Date!B42<=TODAY()+3,AD41-G41-H41-F41+S41,""),0),"")

Zagarott_3-1658102247405.png

 


Zagarott_0-1658101926187.png

The information is now stored like this in Power BI,  Columns being Date, Received, Processed and Backlog (the numbers imported from the excel table.)

Zagarott_1-1658102090196.png

 

 

Thanks in advance!

2 REPLIES 2
Anonymous
Not applicable

Hey,

Unfortunately that doesn't look to work.

Currently this is what the data is outputting.

The old backlog is what I have manually entered from the Excel data, So Old Backlog is the target outcome i need.
The Recevied, Processed are just values as shown.
So need to work out how to get the Total Backlog to line up with Old Backlog.

 

Total Backlog is using the measure.

Backlog M =
 
 CALCULATE(SUM('Returns_Inboud/Outbound'[Total Units Processed]),filter('Returns_Inboud/Outbound','Returns_Inboud/Outbound'[Title1] <=maxx('Returns_Inboud/Outbound','Returns_Inboud/Outbound'[Title1]))) - CALCULATE(SUM('Returns_Inboud/Outbound'[Total Returns Received]),filter('Returns_Inboud/Outbound','Returns_Inboud/Outbound'[Title1] <=maxx('Returns_Inboud/Outbound','Returns_Inboud/Outbound'[Title1])))
 

Zagarott_0-1658178648351.png

 

amitchandak
Super User
Super User

@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.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors