Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello,
I have a range named "Tab" with dates in columns,
After some transformations, if I change the column "Attribute" to date type, I have a column with errors.
How to correct the last step to transform this column in date ?
Thanks in advance
Regards
janv-23 | févr-23 | mars-23 | avr-23 | |
Name | 94 | 21 | 74 | 78 |
A | 65 | 57 | 37 | 84 |
B | 54 | 38 | 30 | 29 |
C | 23 | 23 | 90 | 92 |
D | 68 | 62 | 84 | 57 |
let
Source = Excel.CurrentWorkbook(){[Name="Tab"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type any}, {"Column3", type any}, {"Column4", type any}, {"Column5", type any}}),
#"Promoted Headers" = Table.PromoteHeaders(#"Changed Type", [PromoteAllScalars=true]),
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Promoted Headers", {"Column1"}, "Attribute", "Value"),
#"Changed Type1" = Table.TransformColumnTypes(#"Unpivoted Other Columns",{{"Attribute", type date}})
in
#"Changed Type1"
Solved! Go to Solution.
Hi, @Mederic . Feed Power Query with correct date representation in "MMM-yy" format. As far as I know in "fr-FR" locale the date must be like "janv.-23", not "janv-23" and so on.
Hello @AlienSx ,
Thank you for your message and sorry for the late reply.
I hadn't thought about the regional settings, indeed the 2 steps below work and solve the problem
thanks again
Regards
#"Changed Type with Locale" = Table.TransformColumnTypes(#"Unpivoted Other Columns", {{"Attribute", type datetime}}, "fr-FR"),
#"Changed Type1" = Table.TransformColumnTypes(#"Changed Type with Locale",{{"Attribute", type date}})
Hi, @Mederic . Feed Power Query with correct date representation in "MMM-yy" format. As far as I know in "fr-FR" locale the date must be like "janv.-23", not "janv-23" and so on.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
10 | |
8 | |
6 | |
6 | |
6 |