Power query Table transform columns add data type

[Dicken]

Hi,
This is a two fold quetion,

if I have a column transformation ;

Please Login or Register  to view this content.

Can I apply a data type , type number / Int64.type within this? I've tried and get errors,

The second question is where I have the number 2 , is it possible to refer to another column ?

Adding another column works;

Please Login or Register  to view this content.

I've attached the workbook I've used here.

Richard.

[sandy666]

see:

Please Login or Register  to view this content.

typenumber.png

it works in the second query

Please Login or Register  to view this content.

[Dicken]

Thanks,
I was putting the type outside of the Transformation {} ,
Richard.

[sandy666]

Welcome

[Dicken]

Regarding the seocond part of the question, transforming one column by another I found a post on Stack, which helped and cam up with this,

Please Login or Register  to view this content.

And then wrap in Table from records,
I've updated the attachments showing the working out if anyone is interested.

RD