Forum Discussion
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...
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]) )
Hi amitchandak
I tried both of them but still not working. When I try your suggestion it gives me just 2 Product Type but has to be 5 like Core Product, Identity, NPI, Custom, outofscope, and the NPI calculation is wrong as well.