Forum Discussion
Differentiate between Text & Number and if Text return as Zero
Hello Everyone, I have a column having results which comprise numbers and text. I am looking to create a new measure which shall work on the logic that if there is a number value in the existing col...
Hi Anonymous
you can try this measure
when the current row contains "BDL", CONTAINSSTRING() will return true, then test will return 0, else return current row.
test = IF(CONTAINSSTRING( MIN('Table'[Existing Column]),"BDL"),0,MIN('Table'[Existing Column]))Regards,
OliT
OliT
Resolver I
Resolver IHi Anonymous
you can try this measure
when the current row contains "BDL", CONTAINSSTRING() will return true, then test will return 0, else return current row.
test = IF(CONTAINSSTRING( MIN('Table'[Existing Column]),"BDL"),0,MIN('Table'[Existing Column]))
Regards,
OliT