Power BI Power Query Quick Tips

Preserving Types When using “Add Custom Column” in Power Query

Post author By Jake Bolton
Post date 2021-01-13
No Comments on Preserving Types When using “Add Custom Column” in Power Query

The default UI sets your column to type any.

You can use the optional argument of Table.AddColumn to set it to number

Or you can declare your function’s return type

Why doesn’t the original `[Num] * 2` work?

Powerquery does not know what type will be returned by your function. That’s because each is by definition a function that returns type any

See More

see the each expression in the Lexical Grammar
Docs on Power Query each functions

Tags Power BI, Power Query, tip

Leave a Reply Cancel reply

You must be logged in to post a comment.