DAX Fridays! #64: GENERATE, GENERATEALL

[@BilalZia]

Excellent Ruth. This one can be extremely useful especially when joins loads the power query too much and data refresh starts to take alot time.

[@CurbalEN]

Hi Bilal! Really useful for tons of things, great functions :) /Ruth

[@soy34mb]

Me encantó este video!!! Hoy con lo que estoy trabajando lo veo mas relevante que nunca! No dejes de seguir publicando, aportas tanto a la comunidad de PBi. Muchas gracias.

[@CurbalEN]

Un placer Jimmy ! /Ruth

[@Victor-ol1lo]

Join with conditions on the fly - looks like a very helpful option in DAX. Thanks Ruth. Wish you a Merry Christmas !!!

[@CurbalEN]

Hi Victor! Merry Christmas to you and your family and a glorious 2018 ;) /Ruth

[@dirksmeyers877]

Merry Christmas Ruth and thank you for all the nive videos!

[@CurbalEN]

Merry Christmas to you Dirk and thanks for watching all this time :) /Ruth

[@jorgedelgado4846]

Excelent Curbal! Thanks!

[@watervalle1585]

Suuuuper claro!!!! muchas gracias

[@CurbalEN]

🥳

[@josepromero1452]

Thank You Ruth. All your tutorials are quite interesting, but specially the ones with tables. Merry Christmas!!

[@CurbalEN]

Thanks Josep, I will try to do more of those :) /Ruth

[@saibigdata4046]

Hey Ruth ..Merry Christmas & Happy New Year, Thanks u sharing your knowledge

[@CurbalEN]

Hi Sai! Merry Christmas to you too and happy new year!! 🎈

[@jasonwoodward5501]

Ruth, this is good. Thank you.

[@rolandotemporale791]

Thanks Ruth!, very clear explanation.

[@CurbalEN]

Great! And Merry Christmas to you and your family :) /Ruth

[@rolandotemporale791]

Merry Christmas to you !! Feliz Navidad !!

[@CurbalEN]

Feliz Navidad :) 🎄

[@Henrik.Vestergaard]

Super cool video, thanks.

[@ankushkumarjoshi6661]

Nice video Ruth.

[@CurbalEN]

Thanks Ankush, glad you liked it :) /Ruth

[@annarozyc5184]

thx for your work

[@CurbalEN]

And thanks for watching :)

[@waltertiggeloven]

Another great video.

[@CurbalEN]

Thanks! New to the channel? /Ruth

[@waltertiggeloven]

Hmm, not really. I like to improve my skills by watching instruction video's every now and then. Or in fact, I watch almost every day a few. I already subscribed to your channel months ago. Today I was triggered by this weeks 'DAX Fridays' and one thing (video) led to another (video). LOL I have to say, I love your way of explaning. 👍🏻

[@CurbalEN]

Thanks! Fantastic if my videos are helpful and thanks for watching for so long :) Have a great weekend :) /Ruth

[@waltertiggeloven]

Like one of your explainations I only came across today: the key is reverse engineering. Watching videos and than rebuilding the formulas and adjusting them to my needs is the way I learn. Nowadays learning codes and solutions is so much easier. I still remember the pre-internet days. Then only source code of applications could be used for reverse engineering. There were so little sources to searchj for solutions. Buying a book 📖 was an option though. 😂 Do not doubt the usefulness of your videos. I'm sure they help a lot of people. Remember that only a small percentage of them take the trouble of leaving a note or even a thumbs up 👍🏻. You too have a great weekend. Hope it will be a little warmer than the 4°C. 😜 /Walter

[@CurbalEN]

It sounds like we come from the same school 😂😂 I wish I had google when I was a student... better late than never though! It is extremely gratifying to know that the videos are useful, all the work behind becomes play instead! I have been promised 14C for tomorrow, so my golf clubs are now polished and ready 🏌️‍♀️! :) /Ruth

[@danilochavez4167]

Lo máximo! Gracias!!

[@CurbalEN]

Felices Fiestas!!!🎄 /Ruth

[@danilochavez4167]

Curbal Feliz navidad Ruth! Pásala lindo. Un abrazo!

[@CurbalEN]

Igualmente :) Feliz Navidad para ti y tu familia 🎅 /Ruth

[@Darknesslc3]

at 3:24 u said "matching rows" but is that really correct? It is just returning all possible combination without the need to match isnt it

[@rrrprogram8667]

Thanks... Good one

[@CurbalEN]

Excellent! Glad you liked it! :) /Ruth

[@marianneblanck8280]

Hi Ruth! do you know if it's possible to reset a What If parameter back to default? Once I publish the report and users start playing with the parameters, the default feature is basically inexistent? Or is there a way to assign a value to it by clicking a button?

[@MarkCBB86]

This is a great video. I do have a question, let's say I want to create a table that has all rows from both tables, but only some of the columns, how would I go about doing this?

[@CurbalEN]

You can check out the union and selectedcolumns video :) /Ruth

[@majdyazigi8185]

Merry Christmas Ruth, nice video, could you please provide the link of the video where you explain the relations in Excel many thanks

[@impulse_101]

Hi! If I understood correctly, you say that crossjoin is same that full outer join? It's different things. If i will use crossjoin function on 7 rows table with 4 rows table with no matches, the result will be 28 rows table. With Full outer join result would 11 rows!

[@LandscapeInMotion]

Wow!! Finally some flexibility! Naturalouterjoin does not handle calculated tables..

[@CurbalEN]

Glad it was useful :) /Ruth

[@nishantkumar9570]

How to create a new table in Excel Power Pivot

[@CurbalEN]

Hi Nils, Maybe this works in excel? Give it a go! m.kzbin.info/www/bejne/ppnSlolthrl1oLs /Ruth

[@nishantkumar9570]

Curbal thanks for sharing this video. This is very helpful. But I was asking help in using "generate" in Microsoft Excel, as there is no option for creating new table in Excel Power Pivot.

[@CurbalEN]

But, with that you can create a table, don’t know if it works in excel though. Obviously I am misunderstanding something.... /Ruth

[@nishantkumar9570]

Curbal yeah, I completely understand that. Thank you very much again.