cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
twahl Frequent Visitor
Frequent Visitor

format dax

Hello all.  

 I am writing Dax but I cannot seem to figure out how to carriage return in the formula bar.  my code is all one line. is there a way to format with indents and carriage returns? 

 mycolumn = CALCULATE(COUNT('table1'[column1]))

 

I would like to have a clean look like

AcitvePending = CALCULATE(
                                               COUNT('table1'[column1])
                                              )

 

thanks, 

Tom

2 ACCEPTED SOLUTIONS

Accepted Solutions
Anonymous
Not applicable

Re: format dax

Hi @twahl,

 

Actually your DAX formula has the correct indentation. But if you want to give those line breaks use shift + enter.
You can use the https://www.daxformatter.com/ tool to indent your DAX formulas according to a popular standard.

 

Regards.

Hardik Established Member
Established Member

Re: format dax

https://stackoverflow.com/questions/35921010/is-there-a-way-to-add-line-breaks-in-a-string-of-text-i...

I hope this article helps you to provide you with the desired solution.

3 REPLIES 3
Anonymous
Not applicable

Re: format dax

Hi @twahl,

 

Actually your DAX formula has the correct indentation. But if you want to give those line breaks use shift + enter.
You can use the https://www.daxformatter.com/ tool to indent your DAX formulas according to a popular standard.

 

Regards.

Hardik Established Member
Established Member

Re: format dax

https://stackoverflow.com/questions/35921010/is-there-a-way-to-add-line-breaks-in-a-string-of-text-i...

I hope this article helps you to provide you with the desired solution.

twahl Frequent Visitor
Frequent Visitor

Re: format dax

Thanks all. Both ideas with the HTML and the shortcut keys are super helpful.