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.
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 ...
Thank you for your efforts in creating the M book; I truly appreciate the detailed screenshots-they are incredibly helpful. However, I’ve noticed that the autocomplete feature (Intellisense) in Power Query is not functioning in the Excel files provided with the book. I’ve thoroughly checked the settings on my device, and everything appears to be configured correctly. It seems this issue is specific to the files included with the book. Could you please advise?
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.
Yeah I messed up. Guess there are 6 winners now 😁
Just got your book 📚, love the tutorials! 🙌 Thanks a ton! 😊
I rewatch video for restudy ..it’s awesome again and again …
Hi, pleased to be here, Brahim from Morocco.
49:29 How do we know that it should be “Text.From”, as opposed to “Number.To”, for example?
Thanks!
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)?
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 ...
Thank you for your efforts in creating the M book; I truly appreciate the detailed screenshots-they are incredibly helpful. However, I’ve noticed that the autocomplete feature (Intellisense) in Power Query is not functioning in the Excel files provided with the book. I’ve thoroughly checked the settings on my device, and everything appears to be configured correctly. It seems this issue is specific to the files included with the book. Could you please advise?
Will the hard copy in color format?
Paperback available in Canada would be great!!!
Will you be writing a book on DAX next?!
Listening in Gladstone, Missouri, USA. Diving into M
I have recently purchased the electronic book
How do you like it?
Can you write a book on SharePoint lists ..
Is it useful to use VSCode with MCode extension?
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?
chandeep.chhabra@gmail.com :)
Kenya says good evening!
Huntsville Ontario
Florida, USA - User Interface, but I know a little M, so that I can modify the code as needed.
From México
yes
👍
Both
yes