Set A Custom Column Type in M with Zero Extra Steps

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
Share This:

Stay up to date with the latest customer data news, expert guidance, and resources.

More Resources

Your Data, Analytics & AI Partner

Industry leaders choose SkyPoint as their comprehensive and compliant Modern Data Stack Platform. A Certified Microsoft Solutions Partner, SkyPoint Cloud turns siloed data into connected experiences.