Forum Discussion

chris05's avatar
chris05
Frequent Visitor
2 years ago
Solved

Expressions that yield variant data-type cannot be used to define calculated columns

Hi  I'm new to Power BI. Can anyone help me on this error, please "Expressions that yield variant data-type cannot be used to define calculated columns"   RemainingSlots = SWITCH( TRUE(), [Max]...
Need Help
Tutorial Requests
  • lbendlin's avatar
    lbendlin
    2 years ago

    You are trying to return both text and numbers in that column,

     

    RemainingSlots = SWITCH( TRUE(),
    [Max] = 0, "x",
    [Max] - [Min] = 0, "full",

    [Max] - [Min] < 0, "less",

    [Max] - [Min] > 0, FORMAT([Max] - [Min],"#")
    )

lbendlin's avatar
lbendlin
Super User
2 years ago

You are trying to return both text and numbers in that column,

 

RemainingSlots = SWITCH( TRUE(),
[Max] = 0, "x",
[Max] - [Min] = 0, "full",

[Max] - [Min] < 0, "less",

[Max] - [Min] > 0, FORMAT([Max] - [Min],"#")
)