I’m trying to create a date table with a corresponding text column for each date. Like in the table below.

Date with Corresponding Text

I have the below DAX which should create a table of dates from 2018 until now but can’t seem to figure out how to attach the text.

**Calendar_Table =

RETURN
ADDCOLUMNS (
CALENDAR (DATE(2018,01,01), EOMONTH(TODAY(), -1))
)**

Anyone able to help? Many Thanks

I’ve tried adding the following line within the ADDCOLUMNS function.

“TEXT”, {“Text1”, “Text2”, “Text3”},

but it doesn’t respond well to this.