Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I have a table with 200 date columns.
They are displayed in a long format. I'd like to have it displayed such as 26/10/2015
I know how to change the format column by column, but it will be long. Is there a way to change it all at once?
Thanks in advance!
Ana
Solved! Go to Solution.
Hi, @AFra
Please try follow steps:
1. Select all fields in the table in the "Model view" (select a field first,then ctrl+A to select all fields)
2.Change the data type and format as follows:
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @AFra
Please try follow steps:
1. Select all fields in the table in the "Model view" (select a field first,then ctrl+A to select all fields)
2.Change the data type and format as follows:
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
thanks a lot! it works nicely and it's going to save me a LOT of time : )
Hi @AFra ,
yes this is possible in the advanced editor.
First specify the columns you want to change the data like:
custom1 = List.Skip(Table.ColumnNames(Source),10), --> this is if you want to select column 10 onwards.
Then you can change the type of all the slected columns in custom1 by:
changetype = Table.TransformColumnTypes(Source,List.Transform(Custom1, each {_,type date}))
after "type" you can enter the date time you want.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |