Great explaination. Thank you so much! You saved me a lot of time and headache. FYI...My Power Query counts the week from 0 to 6 instead of 1 to 7 (in the example my Monday =0 instead of Monday =1 so I need to filter weekdays
Absolutely brilliant - I've tried so many different ways to work this code out using Chat GPT, Bard, other CZcams videos. This gave me the best results 😀 Thanks so much
Great tutorial, thanks! One thing, Date.DayOfWeek returns values from 0 to 6 however so to remove both Saturdays and Sundays your conditional check should be "
Great video, and great explanation on how to do it step by step. Have you experienced any delay in this function? In my case it processes row by row very slowly. Has this happened to you? Thanks!
Great explaination. Thank you so much! You saved me a lot of time and headache. FYI...My Power Query counts the week from 0 to 6 instead of 1 to 7 (in the example my Monday =0 instead of Monday =1 so I need to filter weekdays
Same happened to my, had to use
I spent the last 2 hours not understanding why my numbers were off until I saw this comment. Thank you so much mate !
Ur teaching style is very impressive nd it helps students nt to get bored during the video......Thnk u for this valuable content ❤️
Thanks and welcome
Very good explanation. It gave me success!
Thanks for your explanation.
Absolutely brilliant - I've tried so many different ways to work this code out using Chat GPT, Bard, other CZcams videos. This gave me the best results 😀
Thanks so much
man your code is perfect, however, you have to remove the equal from
Agree.
Date.DayOfWeek return values 0 to 6, so value = 5 is Saturday in case where Monday is first day of week.
Remember the power query internal index start with 0. In excel start with 1
You are amazing, thank you so much, this was very helpful
Great tutorial, thanks! One thing, Date.DayOfWeek returns values from 0 to 6 however so to remove both Saturdays and Sundays your conditional check should be "
Thank you! Great video, it was a great help for me.
Great video! Exactly what I was looking for.
Not exactly sure what just happened, but I will be copying and pasting this custom function into my workbook!
1st view and 1st like 😘
😊😊👌👌👌👌
Mashaallah bhai
Just noticed the results don't match the excel example from the beginning. In order to get it to match, I had to change the direction from
Nice
Great video, and great explanation on how to do it step by step.
Have you experienced any delay in this function? In my case it processes row by row very slowly. Has this happened to you? Thanks!
Great content buddy. From where did you learn M code
From Leila Gharani M code course
@@xlstudiovba awesome
@@xlstudiovba thank you for sharing
@@xlstudiovba Can you share the link of the course with me, please
It's on udemy
How to create custom function for target date. I.e adding 10 working days to a date to get a target date
Agree with this one. Can't get mine to work where I have a start date + 8 work days.
When one video has 12 other points that could have their own videos.