topic Re: Trying to build a Line of Balance/Stock Balance chart in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-build-a-Line-of-Balance-Stock-Balance-chart/m-p/3262910#M120718 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="369047" data-lia-user-login="AppleUSN" class="lia-mention lia-mention-user">AppleUSN</a>,</P> <P>Perhaps you can take a look at the Greg’s blog about some common usage scenarios if they meets to your requirements:</P> <P><A href="https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882#:~:text=You%20have%20a%20%E2%80%9Cstart%20date%E2%80%9D%20and%20an%20%E2%80%9Cend%20date%E2%80%9D" target="_self">Before You Post, Read This: start, end date</A>&nbsp;<BR />Regards,</P> <P>Xiaoxin Sheng</P> Thu, 01 Jun 2023 02:21:00 GMT Anonymous 2023-06-01T02:21:00Z Trying to build a Line of Balance/Stock Balance chart https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-build-a-Line-of-Balance-Stock-Balance-chart/m-p/3260047#M120521 <P>I have a need to show the balance of quantity over a period of time based on supply and demand.&nbsp; 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.&nbsp; 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.&nbsp; I am trying to figure out how to calculate the position row below.&nbsp; I can get the demand and commit qty no problem.&nbsp; I can also show the difference between the two but I cannot figure out the difference with the running total.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>4118215-01</TD><TD>Past Due</TD><TD>29-May</TD><TD>5-Jun</TD><TD>12-Jun</TD><TD>19-Jun</TD><TD>26-Jun</TD><TD>3-Jul</TD><TD>10-Jul</TD><TD>17-Jul</TD><TD>24-Jul</TD></TR><TR><TD>Demand Qty</TD><TD>19</TD><TD>1</TD><TD>5</TD><TD>4</TD><TD>2</TD><TD>2</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>Supplier Commit Qty</TD><TD>&nbsp;</TD><TD>1</TD><TD>5</TD><TD>7</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD><U>Position</U></TD><TD>&nbsp;</TD><TD><U>(19)</U></TD><TD><U>(19)</U></TD><TD><U>(16)</U></TD><TD><U>(17)</U></TD><TD><U>(19)</U></TD><TD><U>(19)</U></TD><TD><U>(19)</U></TD><TD><U>(19)</U></TD><TD><U>(19)</U></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Feed Data</P><TABLE><TBODY><TR><TD>Part Number</TD><TD>Qty Open</TD><TD>Contract Date</TD><TD>Dock Date</TD></TR><TR><TD>4118215-01</TD><TD>1</TD><TD>4/18/2023</TD><TD>4/18/2024</TD></TR><TR><TD>4118215-01</TD><TD>1</TD><TD>4/19/2023</TD><TD>4/18/2024</TD></TR><TR><TD>4118215-01</TD><TD>1</TD><TD>4/20/2023</TD><TD>4/18/2024</TD></TR><TR><TD>4118215-01</TD><TD>1</TD><TD>4/24/2023</TD><TD>4/18/2024</TD></TR><TR><TD>4118215-01</TD><TD>1</TD><TD>4/25/2023</TD><TD>4/18/2024</TD></TR><TR><TD>4118215-01</TD><TD>1</TD><TD>4/27/2023</TD><TD>4/18/2024</TD></TR><TR><TD>4118215-01</TD><TD>1</TD><TD>4/28/2023</TD><TD>4/18/2024</TD></TR><TR><TD>4118215-01</TD><TD>1</TD><TD>5/3/2023</TD><TD>4/18/2024</TD></TR><TR><TD>4118215-01</TD><TD>1</TD><TD>5/5/2023</TD><TD>4/18/2024</TD></TR><TR><TD>4118215-01</TD><TD>1</TD><TD>5/8/2023</TD><TD>4/18/2024</TD></TR><TR><TD>4118215-01</TD><TD>1</TD><TD>5/10/2023</TD><TD>4/18/2024</TD></TR><TR><TD>4118215-01</TD><TD>1</TD><TD>5/12/2023</TD><TD>4/18/2024</TD></TR><TR><TD>4118215-01</TD><TD>1</TD><TD>5/15/2023</TD><TD>4/18/2024</TD></TR><TR><TD>4118215-01</TD><TD>1</TD><TD>5/16/2023</TD><TD>4/18/2024</TD></TR><TR><TD>4118215-01</TD><TD>1</TD><TD>5/18/2023</TD><TD>4/18/2024</TD></TR><TR><TD>4118215-01</TD><TD>1</TD><TD>5/22/2023</TD><TD>4/18/2024</TD></TR><TR><TD>4118215-01</TD><TD>1</TD><TD>6/1/2023</TD><TD>4/18/2024</TD></TR><TR><TD>4118215-01</TD><TD>1</TD><TD>6/5/2023</TD><TD>4/18/2024</TD></TR><TR><TD>4118215-01</TD><TD>1</TD><TD>6/6/2023</TD><TD>4/18/2024</TD></TR><TR><TD>4118215-01</TD><TD>1</TD><TD>6/7/2023</TD><TD>6/1/2023</TD></TR><TR><TD>4118215-01</TD><TD>1</TD><TD>6/8/2023</TD><TD>6/5/2023</TD></TR><TR><TD>4118215-01</TD><TD>1</TD><TD>6/9/2023</TD><TD>6/6/2023</TD></TR><TR><TD>4118215-01</TD><TD>1</TD><TD>6/13/2023</TD><TD>6/7/2023</TD></TR><TR><TD>4118215-01</TD><TD>1</TD><TD>6/13/2023</TD><TD>6/8/2023</TD></TR><TR><TD>4118215-01</TD><TD>1</TD><TD>6/14/2023</TD><TD>6/9/2023</TD></TR><TR><TD>4118215-01</TD><TD>1</TD><TD>6/16/2023</TD><TD>6/13/2023</TD></TR><TR><TD>4118215-01</TD><TD>1</TD><TD>6/19/2023</TD><TD>6/13/2023</TD></TR><TR><TD>4118215-01</TD><TD>1</TD><TD>6/20/2023</TD><TD>6/14/2023</TD></TR><TR><TD>4118215-01</TD><TD>2</TD><TD>4/26/2023</TD><TD>6/16/2023</TD></TR><TR><TD>4118215-01</TD><TD>1</TD><TD>6/27/2023</TD><TD>6/16/2023</TD></TR><TR><TD>4118215-01</TD><TD>1</TD><TD>6/29/2023</TD><TD>6/16/2023</TD></TR><TR><TD>4118215-01</TD><TD>1</TD><TD>4/26/2023</TD><TD>6/19/2023</TD></TR></TBODY></TABLE> Tue, 30 May 2023 15:59:46 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-build-a-Line-of-Balance-Stock-Balance-chart/m-p/3260047#M120521 AppleUSN 2023-05-30T15:59:46Z Re: Trying to build a Line of Balance/Stock Balance chart https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-build-a-Line-of-Balance-Stock-Balance-chart/m-p/3262910#M120718 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="369047" data-lia-user-login="AppleUSN" class="lia-mention lia-mention-user">AppleUSN</a>,</P> <P>Perhaps you can take a look at the Greg’s blog about some common usage scenarios if they meets to your requirements:</P> <P><A href="https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882#:~:text=You%20have%20a%20%E2%80%9Cstart%20date%E2%80%9D%20and%20an%20%E2%80%9Cend%20date%E2%80%9D" target="_self">Before You Post, Read This: start, end date</A>&nbsp;<BR />Regards,</P> <P>Xiaoxin Sheng</P> Thu, 01 Jun 2023 02:21:00 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-build-a-Line-of-Balance-Stock-Balance-chart/m-p/3262910#M120718 Anonymous 2023-06-01T02:21:00Z Re: Trying to build a Line of Balance/Stock Balance chart https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-build-a-Line-of-Balance-Stock-Balance-chart/m-p/3264021#M120784 <P>Hello Xiaoxin,</P><P>This did help me to find the solution.&nbsp; I still had to dig deeper and create another measure to finish the formula but it did point me in the right direction.</P><P>&nbsp;</P><P>Thanks again.</P> Thu, 01 Jun 2023 14:01:55 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-build-a-Line-of-Balance-Stock-Balance-chart/m-p/3264021#M120784 AppleUSN 2023-06-01T14:01:55Z