Forum Discussion
Changing Dim_date from regional settings to us
That PQ function does not convert a date in a column from one type to another. (It exists to allow PQ to properly interpret a date that is presented in a format different from your local computer settings).
If you do not want to add a new column, but you still want to see dates (as actual dates and not as text representations), another option is to change your Windows Regional Settings to reflect the desired locale (US-English in this case).
You may also be able to change the locale of the file in Power BI options, but I have not tested that method.
For a long date, you will need to add a properly formatted text column.
This can be done in either Power BI or Power query
//DAX in Power BI
US Date = FORMAT('Table'[Column1],"MMMM d, yyyy","en-US")
//M-Code in Power Query
Table.AddColumn(#"Previous Step", "US Date", each Date.ToText([Column1],[Format="MMMM d, yyyy", Culture="en-US"]))For a short date, you can merely set the format (in Power BI) to "MM/dd/yyyy" or similar
thank you,
i do not want to add new column if i am creating source Dim_Date table outside power bi.
I want to just import table and see visuals in proper language which i set up.
I tried to convert Date column using Local settings in power query but it is not working. Still shows Date column as polish one even i have this step added:= Table.TransformColumnTypes(DateColumn, {{"Date", type date}}, "en-US")
This is possible at all?
Best,
JacekThat PQ function does not convert a date in a column from one type to another. (It exists to allow PQ to properly interpret a date that is presented in a format different from your local computer settings).
If you do not want to add a new column, but you still want to see dates (as actual dates and not as text representations), another option is to change your Windows Regional Settings to reflect the desired locale (US-English in this case).
You may also be able to change the locale of the file in Power BI options, but I have not tested that method.
