Extended Date table - language settings

[SamSPAIN]

Hi there!

I’m using the latest improved Date table in a dataset created by our IT department and getting days in French instead of English - despite my computer is all set in English as default.

Extended Date Table (Power Query M function)

Hi @BI_Noob_Forgiveme, That sounds more like a Dynamic Date range slicer… You’ll find all about that here. I hope this is helpful.

I assume this is due to the fact that the IT who created the dataset had its settings in French, still isn’t there any way to have it in English? See below screenshot as a reference showcasing the thing - enclosed is the M code too.TheCalendar.txt (19.1 KB)

Has anyone in the community faced such a thing? Note the code works perfectly well in English when starting from a blank PBI instance.

Thanks a lot for providing here some color.

Best

[Melissa]

Hi @SamSPAIN,

What do the Regional Settings say under Current File in Options & Settings?

Furthermore Power Query locale is based on the regional setting of the operating system but I honestly don’t expect that’s an issue here because in a new file you aren’t experiencing this problem.

[SamSPAIN]

thanks @Melissa - it was French (Switzerland).