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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
AppleUSN
Frequent Visitor

Trying to build a Line of Balance/Stock Balance chart

I have a need to show the balance of quantity over a period of time based on supply and demand.  I am having trouble duplicating this and I cannot find a solution based on my question either so I am hoping the community can help me.  I want to calculate the running total of my stock level based on the demand date and the actual received date to show when I will be positive or negative on stock level.  I am trying to figure out how to calculate the position row below.  I can get the demand and commit qty no problem.  I can also show the difference between the two but I cannot figure out the difference with the running total.

 

4118215-01Past Due29-May5-Jun12-Jun19-Jun26-Jun3-Jul10-Jul17-Jul24-Jul
Demand Qty19154220000
Supplier Commit Qty 157100000
Position (19)(19)(16)(17)(19)(19)(19)(19)(19)

 

Feed Data

Part NumberQty OpenContract DateDock Date
4118215-0114/18/20234/18/2024
4118215-0114/19/20234/18/2024
4118215-0114/20/20234/18/2024
4118215-0114/24/20234/18/2024
4118215-0114/25/20234/18/2024
4118215-0114/27/20234/18/2024
4118215-0114/28/20234/18/2024
4118215-0115/3/20234/18/2024
4118215-0115/5/20234/18/2024
4118215-0115/8/20234/18/2024
4118215-0115/10/20234/18/2024
4118215-0115/12/20234/18/2024
4118215-0115/15/20234/18/2024
4118215-0115/16/20234/18/2024
4118215-0115/18/20234/18/2024
4118215-0115/22/20234/18/2024
4118215-0116/1/20234/18/2024
4118215-0116/5/20234/18/2024
4118215-0116/6/20234/18/2024
4118215-0116/7/20236/1/2023
4118215-0116/8/20236/5/2023
4118215-0116/9/20236/6/2023
4118215-0116/13/20236/7/2023
4118215-0116/13/20236/8/2023
4118215-0116/14/20236/9/2023
4118215-0116/16/20236/13/2023
4118215-0116/19/20236/13/2023
4118215-0116/20/20236/14/2023
4118215-0124/26/20236/16/2023
4118215-0116/27/20236/16/2023
4118215-0116/29/20236/16/2023
4118215-0114/26/20236/19/2023
1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

Hi @AppleUSN,

Perhaps you can take a look at the Greg’s blog about some common usage scenarios if they meets to your requirements:

Before You Post, Read This: start, end date 
Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

2 REPLIES 2
AppleUSN
Frequent Visitor

Hello Xiaoxin,

This did help me to find the solution.  I still had to dig deeper and create another measure to finish the formula but it did point me in the right direction.

 

Thanks again.

v-shex-msft
Community Support
Community Support

Hi @AppleUSN,

Perhaps you can take a look at the Greg’s blog about some common usage scenarios if they meets to your requirements:

Before You Post, Read This: start, end date 
Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors