Can I write a DAX query in more than one row?

[siacc]

Hi all,

I have the following dax expression (for a calculated table):

TableOne = FILTER(SUMMARIZE('persons', 'persons'[id], 'persons'[name], 'persons'[surname]),  'persons'[age] = 34)

This dax expression works. It returns only rows for persons whose age is 34 years old.

But i would split this dax expression in more than one row (for a better readability).

How can I do?

Thank you for your answers.

[MFelix · Accepted solution]

Hi @siacc,

Do you mean something like this:

TableOne = FILTER(
                  SUMMARIZE(
                     'persons', 'persons'[id], 'persons'[name], 'persons'[surname]),
            'persons'[age] = 34)

You jus have to do ALT + Enter in the place you want to do the line break you can also add comments in front of the formula to better understandment see example below.

ableOne = FILTER(   //Filter table
                  SUMMARIZE( //Summarize table accoding to filter
                     'persons', 'persons'[id], 'persons'[name], 'persons'[surname]),
            'persons'[age] = 34) // age higher then 34

Regards

Mfelix

[Anonymous]

You can use Dax Formatter

[MFelix]

Hi @siacc,

Do you mean something like this:

TableOne = FILTER(
                  SUMMARIZE(
                     'persons', 'persons'[id], 'persons'[name], 'persons'[surname]),
            'persons'[age] = 34)

You jus have to do ALT + Enter in the place you want to do the line break you can also add comments in front of the formula to better understandment see example below.

ableOne = FILTER(   //Filter table
                  SUMMARIZE( //Summarize table accoding to filter
                     'persons', 'persons'[id], 'persons'[name], 'persons'[surname]),
            'persons'[age] = 34) // age higher then 34

regards

Mfelix