Custom Column

[Guinaba]

Hi guys,

I am creating a simple custom column:

([A]-[B])/7

, however the data type after creating is Any. The standard way would be to change the data type adding the next step, however I'd like to know whether is possible to include this step within the custom column? Do I have to create a variable? For instance:

Something like:

let
A=([A]-[B])/7,
= Table.TransformColumnTypes(#"Offset Weeks",{{A, Int64.Type}})

Regards

 

[RoryA]

The last argument to Table.AddColumn is the column type so you can specify it in that line

 

[johnny51981]

After you create your Custom Column that includes your formula of ([A ]-[B ])/7, once it loads, the full step will look like this:

= Table.AddColumn(#"Offset Weeks", "New Custom Column", each ([A]-[B])/7)

As @RoryA stated, the last argument is where you can make the change, so that is the last bit that follows your formula.

= Table.AddColumn(#"Offset Weeks", "New Custom Column", each ([A]-[B])/7, Int64.Type)