Forum Discussion
Helper INeed Help with Dynamic Workload Calculation Based on Planned Order and Launched Count in Power BI
Ashish_Mathur sir, thanks for your reply. here is the dummy file I created . please have a look
https://drive.google.com/file/d/11myAEB3DNPQpWmOqtWt33c6yCgkWvjjV/view?usp=drive_link
I am providing some additional information
- I need to substract Launched number from Total Planned Opend Order to get the 'Workload' for the current month and the obtained value will carry forward to next month and will be added to 'Planned Opened Order of that month and will again exclude launched number of that month to get 'workload'
- In case any value turns negative for 'Workload', then we need to consider it 0 and it will again carry forward .
- We can use calculated column if needed as I have now changed the data from Directquery to Import.
I am really struggling with this so I will really be grateful to you if you can provide me the solution if it exists at all ?
Thanks a lot
Helper IAshish_Mathur sir, thanks for your reply. here is the dummy file I created . please have a look
https://drive.google.com/file/d/11myAEB3DNPQpWmOqtWt33c6yCgkWvjjV/view?usp=drive_link
I am providing some additional information
- I need to substract Launched number from Total Planned Opend Order to get the 'Workload' for the current month and the obtained value will carry forward to next month and will be added to 'Planned Opened Order of that month and will again exclude launched number of that month to get 'workload'
- In case any value turns negative for 'Workload', then we need to consider it 0 and it will again carry forward .
- We can use calculated column if needed as I have now changed the data from Directquery to Import.
I am really struggling with this so I will really be grateful to you if you can provide me the solution if it exists at all ?
Thanks a lot
Super UserI cannot take care of the second requirement there. Someone else will help you.