Forum Discussion

rolf1994's avatar
rolf1994
Icon for Helper II rankHelper II
7 years ago

Create a table with dates from a table with only a startdate and enddate

Hi,   I have the following table: ID StartDate EndDate T123 3-8-2018 7-8-2018   I want to create the following table based on my existing table: ID Date ...
Need Help
PattemManohar's avatar
PattemManohar
Icon for Community Champion rankCommunity Champion
7 years ago

rolf1994 Please try this using "New Table" option

 

GenerateDatesOut = SELECTCOLUMNS(CROSSJOIN(CALENDAR(MIN(GenerateDates[StartDate]),MIN(GenerateDates[EndDate])),GenerateDates),"Date",[Date],"ID",[ID])