Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
340
Views
Topic starter
Hi all!
| Date | Week |
| 12/31/2016 | 52 |
in excel, i use =WEEKNUM([@Date],21) for the formula to get the week number that I need. above is the week that I need.
But when I use power query, even if i use Date.WeekOfYear([Date], Day.Monday)), I'm not getting the correct week number.
Below is the result of power query that I can't get to match above.
| Date | p.week |
| 12/31/2016 | 53 |
Thanks in advance!
Posted : 26/02/2020 4:08 pm
Hi Kenneth,
Power Query doesn't have the European date option, but this post offers a workaround.
Mynda
Posted : 26/02/2020 11:53 pm
