I have checked the updated Code of date table which is on Enterprise DNA , Sam mentioned it in a tutorial , what i need is in my country Egypt we start the week in Saturday and i couldn’t modify the code as it only started in Monday,
I need your Help about that,
Thanks
Clicking on the link provided above will bring you to the topic where you can find the code, just scroll and copy the M code into a new blank query as illustrated in many webinars and videos.
Thanks, Mellisa,
ok i copied the code to a blank query and i got a date table
but Saturday came with No. 0
shouldn’t be No. 1 as it is the first day of the week??
Please take some time to read the linked post, you’ll discover that by default (because Power Query is zero based) the first day is set to 0 but you can change that using the WDStartNum(optional parameter of type number, change weekday number from 0…6 to 1…7)
Hi Melissa,
I have tried to make the optional parameter as you advised , but didn’t work,
then i had to change the (M Code) It self and then i chose the optional parameter,
and finally worked ,
Thanks a lot.
You shouldn’t have to modify anything in de M code when passing the optional WDStartNum as you can see below the code works as expected. First day of the week is Saturday and that gets assigned a 1.
I have checked the updated Code of date table which is on Enterprise DNA , Sam mentioned it in a tutorial , what i need is in my country Egypt we start the week in Saturday and i couldn’t modify the code as it only started in Monday,
I need your Help about that,
Thanks
@Abeer. Unsure why you asked the same question again … @Melissa just solved your question with the same title yesterday. Please see earlier answer.
Greg