Get previous day data problem and support needed!

Question

Dear Community,&nbsp;I stuck in a challenging task by getting previous day for next day calculation.&nbsp;In below table,&nbsp; I need to use measure to get prevoius date Balance for next day ini and use that for next day Balance calculation.The logic for Balance:Balance Calculation for line A=(Line A Ini+Line A Production)-(Line A Ini+Line A Production)/(Total Ini+Total Production)*CapacityBalance Calculation for line B=(Line B Ini+Line B Production)-(Line B Ini+Line B Production)/(Total Ini+Total Production)*CapacityCapacity: 10&nbsp;&nbsp;I'm thinking on that solution for a week but could not settle it donw especially in dealing with those in 0 for productoin, could anyone support on that by advise a correct dax measure?&nbsp;A Big Thanks!

lbendlin · Answer

Seems wasteful to repeat the same numbers. What would you lose if you would drop the "Ini" column?

nbu_fff · Answer

lbendlin&nbsp;， 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.&nbsp;&nbsp;

lbendlin · Answer

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 · Answer

lbendlin&nbsp; Pls find my sample data and excel logic&nbsp;https://1drv.ms/f/s!AhkI23dIWO7ygrpXDlKv9uTZro6QMg?e=INk7dN&nbsp;&nbsp;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.&nbsp;

lbendlin · Answer

your Calendar table is not suitable
&nbsp;

Your data model needs to be adjusted

Please explain how the capacity plays into the formula.
&nbsp;

Forum Discussion

Get previous day data problem and support needed!

10 Replies

Related content

Campaign Voucher FAQ & Support

Logic problem?

Slider problems

FILTERING PROBLEM

Refresh problem