🔴 Getting Started with {M} in Power Query | Live Event

[@Bhaskar_Joshi_there]

1:28:12 => When you got No. 20, you selected the 21st row. But for the 2nd and 3rd winners, you selected rows 12 and 153, respectively, Ideally, rows 13 and 154 should have been the winners.

[@GoodlyChandeep]

Yeah I messed up. Guess there are 6 winners now 😁

[@Gorman-84]

Missed the live, but you have taught me so much! In Colorado. Query guy learning M.

[@alexandrebittencourt2517]

Your book {M} is sensational, the reading is a delight, it transmits knowledge with the same clarity and joy that you transmit in your classes. Believe me, at 59 years old I've read a loooooooooooooooooooot

[@GoodlyChandeep]

Thank you so much. It means a lot.

[@getsetgoo3334]

Just got your book 📚, love the tutorials! 🙌 Thanks a ton! 😊

[@sanketsorte]

I rewatch video for restudy ..it’s awesome again and again …

[@brahimidrissi2524]

Hi, pleased to be here, Brahim from Morocco.

[@JJ_TheGreat]

49:29 How do we know that it should be “Text.From”, as opposed to “Number.To”, for example? Thanks!

[@jonallen9910]

Listening in Gladstone, Missouri, USA. Diving into M

[@jonallen9910]

I have recently purchased the electronic book

[@GoodlyChandeep]

How do you like it?

[@JJ_TheGreat]

47:10 Couldn’t you create another table with those months - and then do a merge in Power Query - which still uses the user interface (UI)?

[@JJ_TheGreat]

31:15 But couldn’t you use the UI to do this? Why do we need to write using M from scratch?… It’s just that I thought that the entire point of learning to write M to go beyond the user interface is: a) to be able to do things which are not possible using the user interface; but I suppose you could also - b) to be able to do things a different way, which is easier or more efficient (code-wise) than using the UI. Is this why? Thanks.

[@DavidFowler-e7i]

For the first spin it was 20, but you selected the 21st row (correct to ignore the headers). However for the second spin it was 12 and you selected the 12th row instead of the 13th !! Likewise for the third spin which was 153, you chose the 153rd row instead of 154th. I guess not a huge issue, but I am a stickler for consistency and those who missed out will be disappointed. BTW, The book is fantastic, I am learning so much ...

[@JJ_TheGreat]

Yes, This is not fair… and I don’t even have an entry.

[@JJ_TheGreat]

I bought a hard copy of the book. Question: When and How can I expect to get the bonus tutorials? Thanks.

[@GoodlyChandeep]

drop a mail to [e-mail] with the receipt. We'll set you up :)

[@sscpreparationmadeeasy]

Can you write a book on SharePoint lists ..

[@Bhaskar_Joshi_there]

Will the hard copy in color format?

[@JJ_TheGreat]

Will you be writing a book on DAX next?!

[@trevortravis6539]

Paperback available in Canada would be great!!!

[@andreasitter698]

Is it useful to use VSCode with MCode extension?

[@jeffreysutyla4654]

I would love to see if you would be available to speak virtually at our corporate Excel training event. How can I discuss this with you?

[@GoodlyChandeep]

[e-mail] :)

[@augustinesambasi4334]

Kenya says good evening!

[@JJ_TheGreat]

Florida, USA - User Interface, but I know a little M, so that I can modify the code as needed.

[@trevortravis6539]

Huntsville Ontario

[@rafaelxuarez]

From México

[@alymohamed8779]

yes

[@trevortravis6539]

Both

[@jonallen9910]

👍

[@anuragsaxena4070]

Hi

[@anuragsaxena4070]

India

[@bsdagur7293]

yes

[@anuragsaxena4070]

Hi