Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Relative Dates - Start Monday

Hi   I really need to know how to set my relative start dates to a Monday.  My regional settings are set to UK whch starts Monday, but whenever I add a date into my report and set a relative filter...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi

 

My regional settings are set the same as yours. I've got UK and first day is a Monday.  Even the server I use for the gateway has UK settings. Every report I create on any data wants to use Sunday as the first day? Thanks

aj1973's avatar
aj1973
Community Champion
5 years ago

Hi Anonymous 

Open Power query and

Verify where the server is and use Locale to your Date Column

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi aj1973, unfortunately this didnt work.  I'm still getting Sundayas my first day despite all settings being set to UK and first day Monday?