P‌‌lease help: Automating Mass Testing of DAX Expressions for Bachelor Thesis.

[AnasBoutmitar]

Hi Power BI Community,

I'm an undergrad student working on my bachelor thesis, focusing on AI models for writing DAX expressions, like Calculated Tables. I'm stuck with a challenge and need your expertise.

I have over 750 DAX expressions that I need to automatically test. Here's what I'm looking to find out for each expression:

• If it's syntactically and semantically valid.
• Type of errors (syntax or semantic) and specific error messages.
• For valid expressions, the number of columns and rows returned.

I've been searching for a solution for a week with no luck. Does anyone know a method or tool that can help automate this process? Any advice or suggestions would be immensely appreciated!

Thanks in advance.

[lbendlin]

For the first two points you can use the DAXFormatter API  (check their T&C first).

The third point can be covered by DAX.do by SQLBI  or any SSAS Tabular instance if you bring your own data.