Solved: Re: Ask regarding whole number in Power Query Edit...

NikAmalAiman · ‎10-04-2023

Hi guys!

Just want to ask regarding the Numbers inside this column.

Currently I'm doing the Employee Card and I want to show the Age for each Employee is the same as Employee ID, Employee Name, Race, Religion and Hired Date. You all have any idea? Thank you.

Anonymous · ‎10-05-2023

Hi @NikAmalAiman ,

Actually, it depends on the data type. If the data type of the field is Text type, it will display in the left side of column. And the data type of column [AGE] is Whole Number type, then it should display in the right side of column. This is by design.

Data types in Power Query - Power Query | Microsoft Learn

Best Regards

View solution in original post

Anonymous · ‎10-05-2023

Hi @NikAmalAiman ,

Actually, it depends on the data type. If the data type of the field is Text type, it will display in the left side of column. And the data type of column [AGE] is Whole Number type, then it should display in the right side of column. This is by design.

Data types in Power Query - Power Query | Microsoft Learn

Best Regards