Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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

 

 

Need Help
  • ryan_mayu's avatar
    ryan_mayu
    3 years ago

    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)

     

1 Reply

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    3 years ago

    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)