Forum Discussion
Converting error - unable to convert a data type to the data type requested for table 'column'.
Hi, I have figured out why the error occurs, but not how to solve the problem. When I have a measure that returns a dash "-" when there is no data in a given month and try to combine that in a tab...
Anonymous , Create a new measure that checks if the value is a dash and returns a numeric value or null instead:
DAX
NewMeasure =
IF(
ISNUMBER(VALUE([YourMeasure])),
VALUE([YourMeasure]),
BLANK()
)
bhanu_gautam
Super User
Super UserAnonymous , Create a new measure that checks if the value is a dash and returns a numeric value or null instead:
DAX
NewMeasure =
IF(
ISNUMBER(VALUE([YourMeasure])),
VALUE([YourMeasure]),
BLANK()
)