Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
mmarshalek
Frequent Visitor

Running total columns

‎12-08-2017 09:34 AM

Trying to create a shortage report in PowerBI

Running Totals.PNG

I have an origional balance of inventory and trying to provide a running total... 

Process is as follows:

  1. Inventory Balance - Demand + Purchase Orders = End Balance
  2. End Balance rolls to next day
  3. End Balance - Demand + Purchase Orders = End Balance
  4. Repeat #3

I'm lost on how to approach..  Could us advice...

Labels:
Message 1 of 5
552 Views
0
4 REPLIES 4
DanielRodriguez
Regular Visitor

‎12-08-2017 07:54 PM

hi,

only use the option "Show on rows" properties

Message 5 of 5
521 Views
0
parry2k
Super User
Super User

‎12-08-2017 10:41 AM

Can you post/sharesample data and will get you the solution?  Please mask any sensitive info



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Message 2 of 5
545 Views
0
mmarshalek
Frequent Visitor
In response to parry2k

‎12-11-2017 06:42 AM

Hi Parry2k,

 

Thank you for guiding me on this below are screen shots of the 3 tables I'm using to develop this report...

 

Inventory Table

Inventory Table.PNG

Demand Table

Demand Table.PNG

Purchase Order Table

Purchase Order Table.PNG

 

Thanks again,

Mike

Message 3 of 5
509 Views
0
v-chuncz-msft
Community Support
Community Support
In response to mmarshalek

‎12-14-2017 02:14 AM

@mmarshalek,

 

You may try to create a calculated table.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Message 4 of 5
492 Views
0

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

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.

View All