Forum Discussion
Column Type Data Type clarification in Power Query
Ahhh, in that case, add this to the end of the code in the Advanced Editor for that step:
, Int64.Type
other common types you'll use are:
"type text"
"type date"
"type datetime"
"type number"
Currency.Type
Percentage.Type
An easy way to see what the exact M code is to create a temporary step that changes the data type. Then you'll see in the Advanced Editor exactly how M writes it (type number vs. Int64.Type...never figured out why). Then you can simply use that same spelling as the 3rd parameter of Table.AddColumn().
If you want your measure to return a sum with no decimals, you can simply use:
[Measure] := SUM( TableName[ColumnName] )
Then go to the Modeling tab and choose "Whole Number" as the formatting option.
You can also change the data type of columns in Query Editor.
Chris, sorry if I wasn't clear but I'm working with M, not DAX.
When I'm using something like Table.AddColumn, the third argument is an optional column type. I want to specify that column type to be Int64 rather than number.
Ahhh, in that case, add this to the end of the code in the Advanced Editor for that step:
, Int64.Type
other common types you'll use are:
"type text"
"type date"
"type datetime"
"type number"
Currency.Type
Percentage.Type
An easy way to see what the exact M code is to create a temporary step that changes the data type. Then you'll see in the Advanced Editor exactly how M writes it (type number vs. Int64.Type...never figured out why). Then you can simply use that same spelling as the 3rd parameter of Table.AddColumn().
So the M language has recently standardized the syntax on these data types:
Text.Type
DateTime.Type
Date.Type
Time.Type
Number.Type
for the above list, you can still use "type text" or "type datetime" (the original list I provided).
Int64.Type, Percentage.Type, and Currency.Type only work with this formal Name.Type structure.