Forum Discussion

ang_K's avatar
ang_K
Regular Visitor
3 years ago
Solved

Creating a planning calculator

We have a tool in Excel that has a list of steps in a project plan. The user can enter a start date for the project and all the Start Dates for the steps recalculate (the Start Dates have formulas in...
Need Help
  • v-xiaosun-msft's avatar
    v-xiaosun-msft
    3 years ago

    Hi ang_K ,

     

    According to your description, I suggest that you can use "split columns" in Power Query to transform the table as the screenshot shows.

    Then you can create a calculated column.

     

    Column = IF('Table'[Merged]=BLANK(),'Table'[Step Start Dates],'Table'[Step Start Dates]+'Table'[Merged])

     

    Final output:

    About the steps of "split columns", please reference the applied steps in my sample.

    Split columns by delimiter - Power Query | Microsoft Learn

     

    I attach my sample below for your reference.

     

    Best Regards,
    Community Support Team _ xiaosun

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-xiaosun-msft's avatar
v-xiaosun-msft
Community Support
3 years ago

Hi ang_K ,

 

According to your description, I suggest that you can use "split columns" in Power Query to transform the table as the screenshot shows.

Then you can create a calculated column.

 

Column = IF('Table'[Merged]=BLANK(),'Table'[Step Start Dates],'Table'[Step Start Dates]+'Table'[Merged])

 

Final output:

About the steps of "split columns", please reference the applied steps in my sample.

Split columns by delimiter - Power Query | Microsoft Learn

 

I attach my sample below for your reference.

 

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.