Forum Discussion
Helper IGet previous day data problem and support needed!
Helper Ilbendlin ,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.
Helper Ilbendlin Inspired by your comments now I have solved part of the problem. I used calculated columns to get the data but from my solution seemed I have to create multiple colomns which I beleive not the best solution. Could you pls have look and advise a potential way out?
I posted a new topic for this question.
Repeated Calculated Column Optimization - Microsoft Fabric Community
Thanks.
v-saisrao-msftCommunity Support
Hi NBU_FFF,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
- v-saisrao-msft
Hi NBU_FFF,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.