topic Re: IF is true command in DAX Commands and Tips

IF is true command

Anonymous — Thu, 23 Feb 2023 17:40:58 GMT

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

Greg_Deckler — Thu, 23 Feb 2023 17:45:02 GMT

Anonymous Maybe:

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

TaylorPBI21 — Thu, 23 Feb 2023 19:32:59 GMT

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 — Fri, 24 Feb 2023 08:59:03 GMT

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