IF is true command

[Erika16]

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!! 😊

[TaylorPBI21 · Accepted solution]

Hi @Erika16 ,

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

LinkedIn: www.linkedin.com/in/taylordownes10 

[Erika16]

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

[Greg_Deckler]

@Erika16 Maybe:

IF ( Table[Column1] = "TRUE", 1, 0 )