Day of Week and Locale

[DonalMc]

Anyone know why PBI Desktop would say that the first day of the week in Ireland is Monday?

According to ICU Locale “English (Ireland)” (en_IE) (localeplanet.com) it is Sunday.

[DonalMc]

@Nithinr - thanks - that explains my question!

I resolved it with Date.DayOfWeek([Date], Day.Sunday) as specified in Date.DayOfWeek - PowerQuery M which I should have spotted in the first instance

[Nithinr · Accepted solution]

Countries follow ISO 8601 Standard has first day of week as monday. most of european countries along with ireland uses this, may be this is the reason