@ajayrathod7777 Sure, this is almost new channel and I have a big plan for it. The videos are published every other three days and all the mentioned subjects are part of future posts.
Sir, you are awesome..... Could you make video on joining data with multiple condition like customer name = *Joh*, father name is = Bob*, and date of birth year is 2023...its very challenging for me.... Could you please guide
It solve the problem in this case but it is a kind of hard coded and not efficient if you faced with forexample 12 columns and also consider the columns of new monthes added later, it needs modification every month or using all the month names once might lead to error.
Excellent Omid. Both methods are very brilliants. Thank you!!!
You are welcome!
Wonderful simple and clear explanation in words
@@thebesttechnical3608 Thank you.
Please make video series on Data modelling, data redundancy ,left join merging in Power query
@ajayrathod7777 Sure, this is almost new channel and I have a big plan for it. The videos are published every other three days and all the mentioned subjects are part of future posts.
❤❤👍👍
I love the way you make me understand M
@@boissierepascal5755 You are welcome
Sir, you are awesome..... Could you make video on joining data with multiple condition like customer name = *Joh*, father name is = Bob*, and date of birth year is 2023...its very challenging for me.... Could you please guide
@hussainmeghani8785 Thanks for your kind words, sure I will do it soon.
Isn't it typical COALESCE case? Something like one liner: [Last Value] = [May] ?? [Apr] ??[ Mar] etc...
It solve the problem in this case but it is a kind of hard coded and not efficient if you faced with forexample 12 columns and also consider the columns of new monthes added later, it needs modification every month or using all the month names once might lead to error.
@@PowerMquery Agree. :)
Great video!! Alternative:
=BYROW(C3:G7,LAMBDA(x,LOOKUP(9.9E+307,x)))
@@Excelambda thanks for sharing your solution
سلام. آیا این آموزش ها بخشی از یک دوره هستند؟ چرا شماره ویدیوها ترتیب خاصی نداره؟ یا داره و من نمیبینم 🤔
It's an independent video related to the challenges posted on my LinkedIn.