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'[Agreementt...
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")

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?