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