Optimizing callbacks in a SUMX iterator
ฝัง
- เผยแพร่เมื่อ 22 ส.ค. 2024
- How to optimize a common issue with SUMX iterators by reducing the number of callbacks in the expression.
Article and download: sql.bi/816722?...
How to learn DAX: www.sqlbi.com/...
The definitive guide to DAX: www.sqlbi.com/...
Thank you. Very informative and interesting.
Thanks again for a very insightful approach for this ever painful callback topic ! Never questioned the use of variables within the ADDCOLUMNS/SUMMARIZE approach -> one more lesson, that you have to question almost everything when optimizing complex DAX calculations you cannot make simpler -> just try it differently...🙏
I enjoy this channel immensely!
I've only been using Power BI and DAX for a short time, so I'm still in the beginner phase.
Alberto is speaking to the ""advanced"" crowd, but I can follow about 75% of the content at least !
Amazing video. As always, top level content. Thank you for very clear explanation.
Thank you!
Thank you 👍
Great Work (Y)
I wanted to ask this for so long..
What keyboard you have there? 😊
All the answers here: www.sqlbi.com/blog/alberto/2021/02/14/on-my-recording-gear/
@@SQLBI thank you, that's a really nice workspace.
@@SQLBI Alberto, I am inspired most by the last section on the page about your drive for improvement.
Hey, great vid as always. what software do you use to present these videos that allows you to zoom in and draw boxes, etc. ?
ZoomIt: learn.microsoft.com/en-us/sysinternals/downloads/zoomit
@@SQLBI thank u ❤️
siempre a sido útil usar addcolumns + summarize con iteradores
Can we optimise the callback that happens when we are calculating the cumulative total?
I have a lot of values for which cumulative sum needs to be calculated.