For the less experienced folks like myself. I did not have the "add step after" feature. Probably due to my simple 2016 version. Any way to get this to work like the Amazing Oz himself, I created a "bogus" next step, went to the formula bar and wiped out the contents and type in the "custom" formula shown by the Oz! And Bam! Shazam! It worked! Thanks Oz!
HELL YEAH!!!!! 🔥🔥🔥 AMAZING AMAZING AMAZING! Very intuitive of you to create the "bogus" or "dummy" step. BAM! That makes me so happy! I'm glad you got that thing working. 🏆
Oz.. What a nice trick Man!!.. I am going to use it tomorrow when I get to my office.... I have a list of 60K rows of crappy data. that I have to convert from an accounting software from the 90,s in a meaningful vendors report.. I am going to use that trick of adding the function and reference it on the last step! That was some serious magic
OZ... your trick worked.. man.. I wish I could have screamed in the office this morning. Thanks for all your tricks that I have learned from you over the years of watching your videos. 1 year of vendor payments from crappy unstructured data to a useful and proper data set! Again, Gracias!
Love the video... straight to the M Code and I think I have a use for this, like you said context matters... I’ll let you know when I get to it and how it turns out.
@@OzduSoleilDATA I mean condition for join in the interface is always "=" like, col1.t1=col1.t2. But what if I want to join t1 with t2 on complex condition like customerid.t1=customerid.t2 and date.t1
Mr. Excel fire sir. I want change the following text form into date format in power querry. 70924. Change to 24-sep-2007.and text 171224 change to 24-dec-2017 please help
For the less experienced folks like myself. I did not have the "add step after" feature. Probably due to my simple 2016 version. Any way to get this to work like the Amazing Oz himself, I created a "bogus" next step, went to the formula bar and wiped out the contents and type in the "custom" formula shown by the Oz! And Bam! Shazam! It worked! Thanks Oz!
HELL YEAH!!!!! 🔥🔥🔥 AMAZING AMAZING AMAZING! Very intuitive of you to create the "bogus" or "dummy" step. BAM! That makes me so happy! I'm glad you got that thing working. 🏆
Minute 5:16, your enthusiasm is contagious! Thank you for another fantastic tutorial Oz!
You are so so welcome! 💥
OZ - your training videos are the best!!!!
THANK YOU!
I love you Oz!!! Hey Oz, I got a Custom Function to work : )
I love you, too! My Custom Function is working, as well. 🔥🔥🔥
Oz - thank you for all you do, you put some real excitement back into learning Excel.
Your'e so welcome. And thank YOU!
Oz.. What a nice trick Man!!.. I am going to use it tomorrow when I get to my office.... I have a list of 60K rows of crappy data. that I have to convert from an accounting software from the 90,s in a meaningful vendors report.. I am going to use that trick of adding the function and reference it on the last step! That was some serious magic
BRILLIANT! I want to know how it turns out!
OZ... your trick worked.. man.. I wish I could have screamed in the office this morning. Thanks for all your tricks that I have learned from you over the years of watching your videos. 1 year of vendor payments from crappy unstructured data to a useful and proper data set! Again, Gracias!
Very helpful Oz. Amazing new trick.👍👍👍
Nice hat collection on the background 🙂🙂
Thank you!! 🎉🎉🎉🎉🎉
Wow, very nice. Love the enthusiasm ^^
Thank you!! 💥💥💥
I love you OZ thanks , finally i found your new training.
Too good! Thanks OZ, Waow! very impressive
Thank you!!
This is awesome GURU JI 😎
Faraz JI. THANK YOU!! 💚💚💚
Wonderfull!!!! You are so BRILLIANT !
Thank you! 😃
SUBSCRIBED!
Thank you! WELCOME. 🔥
I know that feeling : ) !
YES YES YES!
More people should experience that feeling of warm elation.
Love the video... straight to the M Code and I think I have a use for this, like you said context matters... I’ll let you know when I get to it and how it turns out.
Please. Let me know how it goes! 👍
Is it possible in power query to filter multiple table based on same parameters and and I need to merge them then I need to take the counts.
I lean toward saying yes, but I haven't seen your data. So, it's hard to be definitive or offer another solution.
boom. Custom function magic from OZ magician....
VOILA!
Thank you!
How to do left join of two query not only on equal condition, for example like in SQL clause ON t1.id=t2.id and t1.date
HMMMM ... I don't understand the question. SQL is a mystery to me.
@@OzduSoleilDATA I mean condition for join in the interface is always "=" like, col1.t1=col1.t2. But what if I want to join t1 with t2 on complex condition like customerid.t1=customerid.t2 and date.t1
Hi Oz, can I make video base on your video? I' will put your video in my link?
Sure. I'd love to see what you create.
@@OzduSoleilDATA Thank for your tutorial.
Here is my result base on yours :)
th-cam.com/video/OLTCd0OZ4OI/w-d-xo.html
No need invoked function
Nice
I loooooove this video :-)
Yeah??? WOW! Thanks so much!
😊
Mr. Excel fire sir. I want change the following text form into date format in power querry. 70924. Change to 24-sep-2007.and text 171224 change to 24-dec-2017 please help
I got a Custom Function to work. But no Dinner!
No dinner? OMG! 😧 You be proud! I'm proud of you! 🔥🔥🔥
Rip a VLOOKUP with POWER Q+ DAX AND RELATED, JAJAJA or RELATEDTABLE, Saludos desde Chile.
Power Query has been such a blessing!
Nope. No more VLOOKUP.