Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Display month names between two dates.

I have multiple projects whose start dates and end dates are given. I have created a column which specify how many months each project runs for.  Now I want to display all the monthnames the project is running for on new rws. Ex: Lets say Project A is runing for 5 months from January to May. Then there should be 5 rows created with all columns and the column that specifies the monthname. In these five rows, each row should be dedicated to a month being displayed in the monthname column.And this hs to be done in Power query. Request anybody to help with the aswer. Thanks in advance.

Need Help
  • slorin's avatar
    slorin
    2 years ago

    Hi, Anonymous 

     

    add a new column then expand into new rows

    = Table.AddColumn(
       Your_Source, 
       "Month_List", 
       each List.Distinct(
          List.Transform(
              {Number.From([Start_Date])..Number.From([End_Date])},
              each Date.ToText(Date.From(_),"MMM-yy"))))

    Stéphane 

1 Reply

  • slorin's avatar
    slorin
    Super User
    2 years ago

    Hi, Anonymous 

     

    add a new column then expand into new rows

    = Table.AddColumn(
       Your_Source, 
       "Month_List", 
       each List.Distinct(
          List.Transform(
              {Number.From([Start_Date])..Number.From([End_Date])},
              each Date.ToText(Date.From(_),"MMM-yy"))))

    Stéphane