Forum Discussion

duggy's avatar
duggy
Advocate II
7 years ago
Solved

Generate date column using generate series

Hi,   I have the following formula that generates a new table with a row for each day between a start and end date from a given table:   Events Table = SELECTCOLUMNS ( GENERATE ( 'sp...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi duggy,

    Based on my test, you could refer to below steps:

    Create a calender table:

    Date Table = CALENDAR(MAX('Table2'[startspecialdaydate]),MAX('Table2'[Endspecialdaydate]))

    Create a new table:

    Result Table = SUMMARIZECOLUMNS('Table1'[StoreId],'Table1'[specialdayname],'Date Table'[Date])

    Result:

     

    You could also download the pbix file to have a view.

     

    Regards,

    Daniel He

v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

Hi duggy,

Based on my test, you could refer to below steps:

Create a calender table:

Date Table = CALENDAR(MAX('Table2'[startspecialdaydate]),MAX('Table2'[Endspecialdaydate]))

Create a new table:

Result Table = SUMMARIZECOLUMNS('Table1'[StoreId],'Table1'[specialdayname],'Date Table'[Date])

Result:

 

You could also download the pbix file to have a view.

 

Regards,

Daniel He