Forum Discussion
query folding and change of column data type
if I understand the language specification correctly Type.Int64 is just an extension of type number. See here:
https://docs.microsoft.com/en-us/powerquery-m/power-query-m-language-specification, (see page 46):
The M type system consists of the following kinds of types:
• Primitive types, which classify primitive values (binary, date, datetime,
datetimezone, duration, list, logical, null, number, record, text, time, type)
and also include a number of abstract types (function, table, any, and none)I would try using 'type number' instead of Type.Int64, hopefully it works (it may be limitation of Direct Query though, which I assume you are using, since you mentioned folding).. You can then change format in DAX separately from the type
Community Championif I understand the language specification correctly Type.Int64 is just an extension of type number. See here:
https://docs.microsoft.com/en-us/powerquery-m/power-query-m-language-specification, (see page 46):
The M type system consists of the following kinds of types:
• Primitive types, which classify primitive values (binary, date, datetime,
datetimezone, duration, list, logical, null, number, record, text, time, type)
and also include a number of abstract types (function, table, any, and none)
I would try using 'type number' instead of Type.Int64, hopefully it works (it may be limitation of Direct Query though, which I assume you are using, since you mentioned folding).. You can then change format in DAX separately from the type
Thanks, luckily that was an easy fix for my issue!