Forum Discussion
Performance of a DAX Formula
Hi,
How can I measure the performance of a DAX measure and column?
I've created a DAX column and it work perfectly but I think I've created a monster and now my PBIX works extremely slow.
Regards,
3 Replies
- v-piga-msft
Resident Rockstar
Hi luxpbi,
Many factors may affect the performance of Power BI, such as large data size, data model and the complex dax expression.
I'm not clear what functions or formula do you use, but you could have a reference of the article below to optimize your performance in Power BI.
https://www.sqlbi.com/articles/optimizing-dax-expressions-involving-multiple-measures/
http://blog.pragmaticworks.com/power-bi-performance-tips-and-techniques
Best Regards,
Cherry
- luxpbi
Helper V
Hi,
Thanks for your response, but what I'm looking for is a tool for testing different measures.
I've already seen the articles.Something like:
What's the name of the tool?
Regards,
- v-piga-msft
Resident Rockstar