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 ...
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 

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