Forum Discussion
Why DATATABLE dax with single column not accepting multiple values
I am getting an error that only single value is expected to pass and unable to understand this. Here I'm creating a new column in existing table.
Mass UoM = DATATABLE("Mass UoM",STRING,{{"Kg"},{"Lb"}})
Anonymous , datatable returns a table, so this is not a function you should use for the column
https://docs.microsoft.com/en-us/dax/datatable-function#return-value
what you need in column
You may have a column like
Switch(True(),
[Column] = 1, "Kg" , "Lb")
4 Replies
- amitchandak
Super User
Anonymous , Hope You are creating a new table. I am able to do that
Table = DataTable("Mass UOM", STRING ,{ {"Kg"}, {"Lb"} } )- amitchandak
Anonymous , datatable returns a table, so this is not a function you should use for the column
https://docs.microsoft.com/en-us/dax/datatable-function#return-value
what you need in column
You may have a column like
Switch(True(),
[Column] = 1, "Kg" , "Lb")