BLAZING FAST DAX QUERIES | HOW TO OPTIMIZE SLOW POWER BI REPORTS AND DAX QUERIES
Вставка
- Опубліковано 1 жов 2024
- In This Video -
- How can I make DAX query faster?
- speed up dax measures
- power bi performance optimization
Get Help into Questions Related to #powerbi , #dax , #powerquery Power BI #datamodeling , #analysisservices and #powerbiservice
Our videos are mostly specific to real time challenges faced into Power BI projects and its solutions. We use smart and most efficient techniques to solve such challenging situations in Power BI and DAX.
Checkout our playlist and SUBSCRIBE to our channel, for all such interesting topics in Power BI.
Check out our website www.powerbihelpline.com and blog-post. for end-to-end power BI solutions, Power BI templates, or any kind of Power BI questions like Power query errors, Authoring and optimizing DAX codes for complex business logic.
Follow us on LinkedIn
/ power-bi-helpline-22a2...
Email- info@pbihelpline.com
@POWERBIHELPLINE
Please explain the logic in last measure, I didn't get it. You are just trying to add results of two calculate functions instead of applying condition.
In the last example it shows that, if we use such conditions inside the iterator function like SUMX() over a large fact table, it will be slow. because it is going to validate over each row for those conditions. at the otherhand. calculate works on modified filter context. so it will first apply those filters, and then will calculate. which will be more efficient as compare to previous.
Horrible
This is a great topic, thanks for sharing!
You are so welcome!
This video is very slow and monotone in delivery - What are the key takeaways?
But the Replaced DAX functions are blazing Fast. Is'nt it?🙂
The Key takeaway is, there are multiple ways to get a particular result, but what is the most optimized way which improves the performance of the overall DAX query.
ai voice is putting me to sleep
great learning , thanks
Glad you liked it!