Forum Discussion

fatconductor's avatar
fatconductor
Frequent Visitor
4 years ago

Projected Stock on Hand Expression Help

Hi there,   I am trying to get a projected on hand formula to work in my dataset. I've created in excel and almost replicated it in PBI, but am running into some issues as i'm a bit new to PBI.   ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi fatconductor ,

 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

 

Best Regards,
Eyelyn Qin

fatconductor's avatar
fatconductor
Frequent Visitor
4 years ago

Hi Evelyn,

I've just dropped you a sample file and my pbix file.
My ultimate goal here is to create a "Projected Stock" value that equals Network SOH - Actual/Forecast + On order. This column would move into the future as as far as my date table is setup.

Excel example below:

 

I've tried to reformat my data in a number of ways and a number of other peoples supposed solutions with the closest I got sort of copying this solution from Reddit.

I'm stumped, creating a future inventory projection and having issues adding known values and projections. : PowerBI (reddit.com)

I did try to pivot my data out so that the measures were their own column but after receiving the the true dataset it is far too big (500mb) and cant be loaded so I need to keep the original dataset untouched (or as much as possible)


The end goal can be a measure if that's easier I just want it plotted on the chart and matrix as below.


Thanks again I really do appreciate the help.