Forum Discussion
Helper IGet previous day data problem and support needed!
Helper Ilbendlin ， Thanks for reply, actually "Ini" is the temp variant. We can drop it so long as the "Balance" could be made per my logic above. It seemed easy in Excel but hard to figure out in PBI.
Super UserPlease provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
- NBU_FFF
lbendlin Pls find my sample data and excel logic https://1drv.ms/f/s!AhkI23dIWO7ygrpXDlKv9uTZro6QMg?e=INk7dN
Now I'm able to make a DAX to fulfill the logic in sub-sum (Value Stream) level, but from second day the line level data still not correct. pls have a good and advise if you could figure it out. Thanks.
- lbendlin
your Calendar table is not suitable
Your data model needs to be adjusted
Please explain how the capacity plays into the formula.
- NBU_FFF
lbendlin ,thanks for your reply. Acutally my calendar table is the customized one which need to remove some special dates. Pls kindly refer to my original one.
Also for the capacity, it calculated in measure ini. e.g. Mar.21 AC01=(Backlog+Mav)- (Backlog+MAV)/Total* Capacity of this value stream= 397365-397365/616242*80000=345779
Hope it clarifies. Pls kindly let me know if more information you need. Thanks again.