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 C...
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
     
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! 😁