Table Column not recognized in IF-Statement

[Anonymous]

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 TABLE'[Year_Month] = "2023/01", 1, 2)

[ryan_mayu · Accepted solution]

@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)