Forum Discussion
Write robust DAX code which is easy to debug and performs well
Hi geiratatea ,
Please review the following links, hope they can help you.
HOW TO IMPROVE POWER BI PERFORMANCE - PART II
Use Performance Analyzer to examine report element performance (can see and record logs that measure how each of your report elements performs when users interact with them, and which aspects of their performance are most (or least) resource intensive.)
Best Regards
Hi:
There are serveral places to help format code correctly.
https://www.daxformatter.com/ for one.
You can also use DAX Studio, Dax.do. TabularEditor(3)
You'll notice they have both Long and Short form methodes for writing the code. Any of these choices should help you see the correct(accepted) way of writing DAX. I hope this answers your question. Thanks..
Hi and thanks for responding. I was thinking more in direction of writing dax logic in a best way. Formatting will of course make it easier to read and will gain readability. my question is about breaking down a business problem into smaller pieces of code that can make it easier to solve. Good technique will guilde us to the target I guess
Hi geiratatea ,
Please review the following links, hope they can help you.
HOW TO IMPROVE POWER BI PERFORMANCE - PART II
Use Performance Analyzer to examine report element performance (can see and record logs that measure how each of your report elements performs when users interact with them, and which aspects of their performance are most (or least) resource intensive.)
Best Regards
