Custom columns are often the lifeblood of any M queries that you build. They give you huge amounts of power but by default remain untyped. You could add a step to type each new column after you create it, or even type them all at the end, but both imply extra steps when what you really want to do is set the data type of the column right in the same step where you define it. In this video we are going to show you how to do exactly that and end up with code that is much cleaner and easier to read.
Most common types:
- type binary
- type date
- type datetime
- type datetimezone
- type duration
- type list
- type logical
- type null
- type number
- type record
- type text
- type time
