Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join 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.

Reply
sidyahmed_pbix
Frequent Visitor

Change type of multiple columns

Hi there,
I need to change the type of some columns in my table below  (all columns endswith z_matches) .

How can i do in power query to change the type from boolean to text.

 

sidyahmed_pbix_0-1658407587416.png



1 ACCEPTED SOLUTION
Vijay_A_Verma
Super User
Super User

Insert this step where #"Changed Type" will need to be replaced with your previous step

= Table.TransformColumnTypes(#"Changed Type",List.Transform(List.Select(Table.ColumnNames(#"Changed Type"), each Text.EndsWith(_,"z_matches")),each {_, type text}))

View solution in original post

2 REPLIES 2
Vijay_A_Verma
Super User
Super User

Insert this step where #"Changed Type" will need to be replaced with your previous step

= Table.TransformColumnTypes(#"Changed Type",List.Transform(List.Select(Table.ColumnNames(#"Changed Type"), each Text.EndsWith(_,"z_matches")),each {_, type text}))
BITomS
Continued Contributor
Continued Contributor

Hi @sidyahmed_pbix,

 

From your screenshot, it doesn't look like you are in Power Query? You first need to go to 'Transform Data' in the Home ribbon, then in the relevant table, you can see the data types in the top left of each column header:

 

OEMTomS_0-1658410807171.png

 

If you left click on the icon, you will see the option to change the data type.

 

Hope this helps.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.