Using GENERATE and ROW instead of ADDCOLUMNS in DAX

Improve DAX queries by using GENERATE and ROW instead of ADDCOLUMNS when you create table expressions.
Article and video: sql.bi/54337?aff=yt
How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt
The definitive guide to DAX: www.sqlbi.com/books/the-defin...

[@anthonypcheng3167]

One of the best tip of DAX function/code. Cool. Love it.

[@Bharath_PBI]

Thank you. Great work as usual. Enjoying DAX 👍

[@tonirapture6440]

Hi Alberto/SqlBi Team,

[@pratikfutane8131]

Great video filled with best practices !! Thank you!

[@AnalyticswithNags]

This is crystal clear explanation. One thing I have in mind for long is that this script basically creating a calculated table using DAX and same thing can be achieved in power query editor as well. So, which one better interns of performance and when to choose power query or DAX to create calculated table.

[@DesertTOON]

Being able to read my code after weekend is hard enough let alone 6 months! Great content BTW

[@joaquimcosta952]

Very very good like always !!!! Thanks for another good material.

[@vivekgupta309]

all your video series are very good. thanks a lot !!!

[@sundarun]

Fantastic Alberto👏🏾

[@sachin.tandon]

Very, very well explained!

[@BernatAgulloRosello]

When I grow up I want to be like Alberto Ferrari 😁

[@excelisfun3903]

Thanks, Alberto, for the VERY helpful video : ) : )

[@maheshk6916]

Explaining nicely like teaching alphabet to a kid

[@marilenadonofrio9787]

Wow! now I'll pick up and rethink in this way all the code I've written so far...

[@NirRobinson]

Great video. Everyone must be open to make changes in the model..

[@shekharkumardas]

Thanks for great explanation

[@questionsformedb8157]

This is beautiful

[@gulhermepereira249]

0:35

[@HeliSal700]

Nice approach. I will look at it as it next time.

[@MrKarimanal]

You are my man