Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
I have a data source that is in mm/dd/yyyy and also includes time. I need to conver this to dd/mm/yyyy and remove the time, but when changing the data type to Date, it errors out. Is there way to resolve this easily?
Solved! Go to Solution.
maybe you can try change type with locale
Proud to be a Super User!
maybe you can try change type with locale
Proud to be a Super User!
you are welcome
Proud to be a Super User!
Check with this code:
#"Changed Type" = Table.TransformColumnTypes(Source,{{"DateColumn", type datetime}}),
#"Removed Time" = Table.TransformColumns(#"Changed Type", {{"DateColumn", each Date.From(DateTime.LocalNow()), type date}})
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
89 | |
84 | |
76 | |
64 |
User | Count |
---|---|
135 | |
112 | |
98 | |
98 | |
92 |