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 ,

 

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?


Best regards,

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    v-lid-msft ,

    I apologize for the delayed response. With all of the COVID-19 issues this task has temporarily taken a backseat at work. I truly appreciate your assistance and once I'm able to get back to this topic I will post a response on how your solution worked.