Tab in Powerpivot formulas

[cr731]

Is it possible to insert a "tab" or "indent" into a Powerpivot formula, so that it's easier to read?

 

[olivierhbh]

Hi Cr,

I don't know about that, but to achieve what you want I use this tool called Dax Formatter from Marco Russo's website:

DAX Formatter by SQLBI

Give it a try!

Olivier.

 

[Matt Allington]

It is not possible to use tabs, but this is what you can/should do


press Shift-Enter to create a new line
Use spaces to space out your code

Both of these have no impact on your code.

I have stacks of tips like this in my book Learn to Write DAX which is specifically written to help Excel users get started