Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

v-lid-msft Thank you for the quick reply,

So far when I merge the tables with the settings you've shown and then expand the few columns I get null values for everything. I'm wondering if the fact that there other levels to the heirarchy is affecting the results. 

 

For example: 

Task 1 exists in North America, LATAM, and EMEA for the same project number. So within Project ABC123 there are multiple Start/Finish dates for Task 1 depending on the region. Does that impact how we would approach this?

 

The way I've added tasks manually in the past was to unpivot my task column, then add a new column with the specific task, populate with a formula referencing the other applicable task, then once again pivoting the data into a task column inclusive of my newly added column. This works...but for 150 columns it's a real pain... 

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi Anonymous ,

 

We can try to create two calculated columns to meet your requirement instead of merge in power query editor.

 

start_column = [Start]+CALCULATE(SUM('Table (2)'[Duration]),'Table (2)'[Task to Reference] = EARLIER('Table'[Task]))
finish_column = [start_column]+CALCULATE(SUM('Table (2)'[Duration]),'Table (2)'[Task to Reference] = EARLIER('Table'[Task]))

 

 

Then we can get the result like this,

 

 

 

 

 

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that we have shared?

 

BTW, pbix as attched.


Best regards,