Forum Discussion
Creating a new table using DAX
Sorry for stupid question in advance- i have to create a new table, only using dax, name it and name the column (for dates since January,1,2019 to February,1,2019). Is it a way i can do it usin...
I guess you're trying to do this
CustomTableName = SELECTCOLUMNS(CALENDAR(DATE(2020,01,01),DATE(2020,07,01)),"CustomColumnName",[Date])
Thank you! Could you also tell me, how can I use it in one DAX query?
I need to create this table and instantly combine it with another table with sales:
Initial data:
Date Sales 1Jan 3 3Jan 6 5Jan 7 I need to receive as a result:
Date Sales 1Jan 3 2Jan 0 3Jan 6 4Jan 0 5Jan 7 6Jan 0 7Jan
0 and I have to create and use a table with dates in one dax query
