Display month names between two dates.

[Anonymous]

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.

[slorin · Accepted solution]

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