I am utilizing Melissa’s extended data table query. I am wanting to represent the first day of the week to be Sunday. I am unable to revise code to do this. Any suggestions or help would be greatly appreciated.
Date.DayOfWeek(#date(2011, 02, 21), Day.Sunday)
Refer to this blogpost for details. Hope this helps!
Instead of the Extended Date table please consider switching to the Basic Date table, among other things this allows you to set the start of week day…
Note that the Extended Date table is an ISO-8601 type calendar, which requires Monday to be the first day of the week.
I hope this is helpful
Thank you very much!
Now my question is code to calculate CURRENT WK# and PREV WK#. I have tried by following Brian Julius’ post [https://blog.enterprisedna.co/get-power-bi-previous-week-values-using-dax-power-query/], but the PREV WK# shows same number.
Any help would be greatly appreciated.
Thanks so much… I was able to incorporate in Extended date table, but decided to use the basic date table. Very helpful.