Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Need help with an IF statement

Hello!

 

I got this code and it works:

Times = IF('Log'[Agreementarea] = "MIDDLE" && 'Log'[Agreementtimes]>1/24/60*90,"Missad","Avklarad") =IF('Log'[AvtalsområdeValue]="NORTH" && 'Log'[Agreementtimes]>1/24/60*105,"Missad","Avklarad")

 

But I would like to insert more "Agreementareas" in this code. I tried with for example "Middle" || "SOUTH" but it doesnt work.. Can someone help me?

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try in

    Times = IF('Log'[Agreementarea] in { "MIDDLE", "SOUTH" } && 'Log'[Agreementtimes]>1/24/60*90,"Missad","Avklarad") =IF('Log'[AvtalsområdeValue]="NORTH" && 'Log'[Agreementtimes]>1/24/60*105,"Missad","Avklarad")

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , Try in

    Times = IF('Log'[Agreementarea] in { "MIDDLE", "SOUTH" } && 'Log'[Agreementtimes]>1/24/60*90,"Missad","Avklarad") =IF('Log'[AvtalsområdeValue]="NORTH" && 'Log'[Agreementtimes]>1/24/60*105,"Missad","Avklarad")

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thank you so much, this helped! I got one last question. I notices that it still says in my diagrams "True" or "False" When I clearly in my code named it either "Missad" or "Avklarad". Do you have any idea what might cause this or should I start another thread?