Solved: IF is true command

Anonymous · ‎02-23-2023

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 · ‎02-23-2023

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 · ‎02-23-2023

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 · ‎02-24-2023

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

Greg_Deckler · ‎02-23-2023

@Anonymous Maybe:

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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...