Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

IF is true command

Could you please help me with the formula for 'IF'  IF ( Table[Column1] = TRUE (), 1, 0 ) I've tried several times but no success. 

 

I need a new varaible:

if 'change planned' = true, then 'New CM' 

if 'change planned = false, then 'CM' 

 

Many thanks!! 😊

 

 

 

 

Need Help
  • TaylorPBI21's avatar
    TaylorPBI21
    3 years ago

    Hi Anonymous ,

     

    Here is the solution😎...

    New Calculated Column = SWITCH(
        TRUE(),
        'Table'[Changed Planned] = TRUE(), 'Table'[new CM],
        'Table'[Changed Planned] = FALSE(), 'Table'[CM]
    )
     

     

    Many Thanks,
     
    Taylor
     

3 Replies

  • TaylorPBI21's avatar
    TaylorPBI21
    Resolver I
    3 years ago

    Hi Anonymous ,

     

    Here is the solution😎...

    New Calculated Column = SWITCH(
        TRUE(),
        'Table'[Changed Planned] = TRUE(), 'Table'[new CM],
        'Table'[Changed Planned] = FALSE(), 'Table'[CM]
    )
     

     

    Many Thanks,
     
    Taylor
     
    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      TaylorPBI21  you are a start! That worked perfectly. Much a ppreciated! 😁