Forum Discussion
Add Conditional Tasks to Existing Schedules
Hello All, I’m trying to add conditional tasks into an existing schedule within Power BI and I’m not sure how to setup applied steps vs. doing all of this manually every time. I have an existing...
Hi Anonymous ,
We can use the following steps to meet your requirement:
1. In the Power Query Editor, we can merge two tables based on the [Task to Reference] and then we can expand the column Project ID, Start and finish
2. Then we can create new calculated columns [start] and [end].
start = Merge1[Table.Start]+[Duration]finish = [start]+[Duration]
Could you please share the logic why Task 2 add 7 days in finish while it has 15 duration?
If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?
Best regards,