Forum Discussion
Helper IGet previous day data problem and support needed!
Super UserSeems wasteful to repeat the same numbers. What would you lose if you would drop the "Ini" column?
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.
- lbendlin
Please 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.