format dax

[twahl]

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

[Anonymous · Accepted solution]

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.

[twahl]

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

[Hardik · Accepted solution]

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.

[Anonymous · Accepted solution]

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.