Solved: How to do get today's date in US format while your...

Anonymous · ‎10-02-2021

Hello

How can I get today's date in US format when my locale is UK?

Thanks!

Fowmy · ‎10-03-2021

@Anonymous

With the September 2021 Power BI Desktop update, you can now change the locale of the format function
https://docs.microsoft.com/en-us/dax/format-function-dax

Today's Date = FORMAT( TODAY() , BLANK()  , "en-us" )

Did I answer your question? Mark my post as a solution! and hit thumbs up

Anonymous · ‎10-05-2021

@Fowmy thanks but is it possible in Power Query?

Fowmy · ‎10-03-2021

@Anonymous

With the September 2021 Power BI Desktop update, you can now change the locale of the format function
https://docs.microsoft.com/en-us/dax/format-function-dax

Today's Date = FORMAT( TODAY() , BLANK()  , "en-us" )

Did I answer your question? Mark my post as a solution! and hit thumbs up

How to do get today's date in US format while your locale is UK?