topic Re: Creating a new table using DAX in DAX Commands and Tips

Creating a new table using DAX

hald1r — Thu, 16 Jul 2020 14:24:50 GMT

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 using DAX?

Tried

CALENDAR(DATE(2019,1,1),DATE(2019,1,1))

but i can't name the table and rename the column for further using in DAX query (i need additional calculations in this query after creating and naming the table, and all it should be done by DAX only).

Thank you!

Re: Creating a new table using DAX

lbendlin — Thu, 16 Jul 2020 14:34:16 GMT

go to the table view in Power BI (second icon), then click "New table" and enter the DAX code for the table that you want, incuding the additional columns.

Re: Creating a new table using DAX

Ste_For94 — Thu, 16 Jul 2020 14:37:42 GMT

I guess you're trying to do this

CustomTableName = SELECTCOLUMNS(CALENDAR(DATE(2020,01,01),DATE(2020,07,01)),"CustomColumnName",[Date])

Re: Creating a new table using DAX

hald1r — Thu, 16 Jul 2020 14:59:53 GMT

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