This answer was very helpful. Does anyone have any idea why it's working like this? I tried specifying a number for the first day of week parameter and it never changed anything.

Only this solution would work but I'm not sure why. The weekday name is correct when run locally and on a native mode server, but is incorrect when running on a powerbi service unless I use the FirstDayOfWeek.System suggestion. Thanks again