DAX Evaluation - Steps Involved

[sid-poly]

Hi,

I was wanting to understand how the DAX query evaluation happens so that It becomes easier for me to write the queries down. Let us say when we are doing SQL we do have the evaluation steps which are divided and that is how the query processes. Is there any way where DAX also has the evaluation procedure?

[AlexisOlson]

Readers here may be interested in the DAX debugger that's supposedly coming to Tablar Editor 3 soon. (I'm planning on buying a license for 3 as soon as that feature is available.)

See the demo here:
Tabular Editor 3: DAX Debugger & Feature Updates (with Daniel Otykier)

[visheshjain]

Hi @sid-poly ,

Try looking up for videos of SQLBI on youtube, which shows them using DAX studio.

DAX Studio will show, how a DAX query is executed in SQL by showing the SQL query.

Hope this helps.

Thank you,

Vishesh Jain

[amitchandak]

@sid-poly , refer if these can help

https://www.sqlbi.com/articles/order-of-evaluation-in-calculate-parameters/

https://www.microsoftpressstore.com/articles/article.aspx?p=2449191

https://www.csgpro.com/blog/order-of-evaluation-in-dax-variables/