Hi All,
i am getting below issue, pls help me to resolve this it
I have a date field ..but these have two types of values in excel.. one is proper date format (2/1/2023) and another is text format but a date value (13-01-2023), neither am I unable to convert this in excel nor in power bi..both are giving problem..
pls help me with how to solve this problem.
when I am converting this in date format, getting the below error.
1 ACCEPTED SOLUTION
Try: Change Type with Locale => Date => English(United Kingdom)
which will generate this code:
#"Changed Type with Locale" = Table.TransformColumnTypes(#"Previous Step", {{"Date", type date}}, "en-GB")
in
Change #"Previous Step" to the name of that step if you are using this instead of the UI.
If that doesn't work, please share
- the original source (the type of source -- eg CSV File) of the data,
- a copy/paste of some data from that source (as text, not a screenshot),
- the M-Code in the advanced editor and
- your Windows Regional short date settings.
Try: Change Type with Locale => Date => English(United Kingdom)
which will generate this code:
#"Changed Type with Locale" = Table.TransformColumnTypes(#"Previous Step", {{"Date", type date}}, "en-GB")
in
Change #"Previous Step" to the name of that step if you are using this instead of the UI.
If that doesn't work, please share
- the original source (the type of source -- eg CSV File) of the data,
- a copy/paste of some data from that source (as text, not a screenshot),
- the M-Code in the advanced editor and
- your Windows Regional short date settings.
