Forum Discussion

elif's avatar
elif
Frequent Visitor
4 years ago

If statement doesn't work

Hello, I have a problem with IF statement which is not working perfectly, do you have any idea why it is not working very well?   is grater = VAR maxtable1 = CALCULATE(MAX('Date'[Date]),USERELATI...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

elif , If this is a column, this will not work

POS Type NEW = IF([is grater] = 1, "NPI", 'Product'[POS type])

 

It needs to be a measure

example

POS Type NEW = IF([is grater] = 1, "NPI", max('Product'[POS type]) )