Forum Discussion
Table Column not recognized in IF-Statement
Hello everybody, I would like to create an IF-Statement based on the month. But when I type it in like this it always return an error. Any way to fix this? Measure = IF('IMTT: MASTER TA...
Anonymous
you can try this
Measure =
IF(SELECTEDVALUE('IMTT: MASTER TABLE'[Year_Month] )= "2023/01", 1, 2)OR
Measure =
IF(MAX('IMTT: MASTER TABLE'[Year_Month]) = "2023/01", 1, 2)
Anonymous
you can try this
Measure =
IF(SELECTEDVALUE('IMTT: MASTER TABLE'[Year_Month] )= "2023/01", 1, 2)
OR
Measure =
IF(MAX('IMTT: MASTER TABLE'[Year_Month]) = "2023/01", 1, 2)