Power Query custom function date type

[Dicken]

Hi,
can you define the output data type in a custom function; I thought , seemingly wrongly, you put it outside the brackets,
so

Please Login or Register  to view this content.

when used as an addcolumn the new column would be type number? it's not, so can it be done and what does a data type out side of hte function
mean ? ( x as type ) as type =>

Richard.

[Dicken]

I seem to have been right, but was expecting the column data type to reflect this.

[CK76]

Column data type and data type of value is separate.

For an example, column could have mixed data type (though not recommended), having number and text etc.

Value will either be specific type or untyped. Not multiple.

[Dicken]

Yes, I have now realized that, just as experiment had output for a number as text and so when eg X * 10 , got error,

is there a way to add the column type ? i have done it for things like this

Please Login or Register  to view this content.

but this works on the whole table, if you want to 'add column' i tried;

Please Login or Register  to view this content.

and due to the comma, 10, type , it (i think) thinks you are starting an new variable,
don't know if there is a way around this?
will marks this up, thanks for the help.

Richard.

[CK76]

First one should be find for adding column. You just need to invoke it within Advanced Editor.

If you want to go the 2nd route...
Don't declare type in function.
But declare it in AddColumn() where you invoke the function.

Please Login or Register  to view this content.

Then when you addcolumn by invoking function.

Please Login or Register  to view this content.

[Dicken]

Thanks,

Richard.

[romperstomper]

Just be aware that doing that doesn't actually convert or validate any of the data in that column to match the type.