Forum Discussion

mibu's avatar
mibu
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago
Solved

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

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...
Need Help
  • TheoC's avatar
    TheoC
    4 years ago

    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

     

mibu's avatar
mibu
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

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's avatar
TheoC
Icon for Community Champion rankCommunity Champion
4 years ago

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

 

  • mibu's avatar
    mibu
    Icon for Microsoft Employee rankMicrosoft Employee
    4 years ago

    Thank you sir!  Appreciate it!  best, mibu

  • zabronm's avatar
    zabronm
    New Member
    2 years ago

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