Entering DAX on multiple lines when creating a new table with DAX

[mibu]

Team,

I am trying to create a Date table with DAX as follows:

1 Date = 

2 ADDCOLUMNS (

3         CALENDARAUTO(),

4         "Year", YEAR ( [Date] )

5 )

But I seem to be able to only enter the code on a single line as follows:

Date = ADDCOLUMNS ( CALENDARAUTO(), "Year", YEAR ( [Date] ) )

Each time I put the cursor, say for example after = and hit Return...  to give myself a new line...  it just runs what DAX code is there.

Pls advise how I can code on multiple lines within...  Data...  Table tools...  New Table icon... 

Thank you!

mibu

[TheoC]

Hi  @mibu 

If you go here: https://dax.guide/calendarauto/

I believe you are not putting the comma , at the end to show that another column needs to be added.

1 Date = 

2 ADDCOLUMNS (

3         CALENDARAUTO () ,

4         "Year", YEAR ( [Date] ) , // The comma here to the left needs to be added then you can add more columns

5 )

Theo

[mibu]

Hey Theo, thanks for the link...  very helpful.

My issue though...  is that when I enter DAX I seem only to be able to do it on a single line...  rather than being able to enter on multiple lines...  by hitting Return after each entry...  do you know how I can get Power BI Desktop to allow me to code on multiple lines...  instead of on a single line...

Attached is what it looks likeOnly able to code on a single line in Power BI Desktop

[TheoC · Accepted solution]

@mibu make sure to hold down the SHIFT button if you want to go to another line 🙂

When typing measures / calculated columns / tables, you need to hold down the SHIFT and then hit ENTER to go to a new line. 

Hope that helps 🙂

Theo

[zabronm]

Thanks @TheoC ... so easy yet so "hidden"

[mibu]

Thank you sir!  Appreciate it!  best, mibu