Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to change data type of columns within groups

Hello,

 

I have created grouping based on two columns and I want to do some tranformation on the group ( like I have to split that column and then sort and then merge within the group) 

I am facing issue while sorting ( when I sort the numbers instaed of 1,2,3...10, I am getting 1,10,2,3,4) It's because of datatype as I have alphanumeric data type for this column. I changed it to integer within group but when I expand the group,datatype is again getting changed to alphanumeric.

Can someone please help on this?

 

Thanks,

Shweta

 

Need Help

1 Reply

  • Mahesh0016's avatar
    Mahesh0016
    Icon for Super User rankSuper User
    3 years ago

    Anonymous  I think you need to change in M code 

     

    = Table.Group(#"Changed Type", {"Name"}, {{"By Name", each List.Sum([No]), type nullable text}})

    Anonymous I hope this helps you!THANK YOU!!