Forum Discussion

Dicken's avatar
Dicken
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

M code nullable values

  Hi,  I have a simple two column table a = text b = numbers,    i have added two columns ,  Table.AddColumn( Source, "N", each Type.IsNullable( Value.Type( [B] ))) I have been trying to use T...
Need Help
  • ronrsnfld's avatar
    ronrsnfld
    2 years ago

    To return columns of type number, try:

    Table.ColumnsOfType(Source,{type nullable number})
ronrsnfld's avatar
ronrsnfld
Icon for Super User rankSuper User
2 years ago

To return columns of type number, try:

Table.ColumnsOfType(Source,{type nullable number})