Forum Discussion

pierre415's avatar
pierre415
Icon for Helper I rankHelper I
9 years ago
Solved

Turn Start Date & End Date columns into one column with

Hey everyone,   I have 2 columns (Start Date and End date), each one specifying a different project, that I need to combine into one column containing all dates for each project. The column should ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi pierre415,

     

    You can follow below steps to use the query:

     

    1. Click on 'fx' to add custom steps.

     

    Previous step name:

     

    2. Replace bold part with your column names and step name.

     

    =Table.AddColumn(#"Changed Type", "Custom", each List.Dates([StartDate], Duration.TotalDays([EndDate]-[StartDate]), #duration(1, 0, 0, 0)))
                 previous step name                          startdate                       enddate   startdate

     

     

    Regards,

    Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi pierre415,

     

    Click on the arrow button and choose 'expand to new row' option:

     

    Regards,

    Xiaoxin Sheng

Jakinta's avatar
Jakinta
Icon for Solution Sage rankSolution Sage
4 years ago
= Table.AddColumn(#"Renamed Columns", "Custom", each if [Start]=[End] then {[Start]} else List.Dates([Start], Duration.TotalDays([End]-[Start]), #duration(1, 0, 0, 0)))
SangLariba1994's avatar
SangLariba1994
Regular Visitor
4 years ago

Hi, how about excluding weekends?