Forum Discussion
sya
Helper I
Helper IIF Function with 2 Conditions and 2 Type
Hi All, No. of RSO Sent Ageing - JO IN to RSO (days) 4 NO DATA 4 6 2 1 2 2 2 2 1 3 1 3 1 NO DATA I tried to create a measure that meets the following co...
Hi sya
You can create a calculated column to get you the output you're after:
Column =
SWITCH (
TRUE () ,
'Table'[Ageing - JO IN to RSO (days)] = "NO DATA" , BLANK() ,
VALUE ( 'Table'[No. of RSO Sent] ) >= 3 && VALUE ( 'Table'[Ageing - JO IN to RSO (days)] ) <= 3 , "Yes" ,
"No" )Attached is a PBIX file to assist.
Theo 🙂
TheoC
Community Champion
Community ChampionHi sya
You can create a calculated column to get you the output you're after:
Column =
SWITCH (
TRUE () ,
'Table'[Ageing - JO IN to RSO (days)] = "NO DATA" , BLANK() ,
VALUE ( 'Table'[No. of RSO Sent] ) >= 3 && VALUE ( 'Table'[Ageing - JO IN to RSO (days)] ) <= 3 , "Yes" ,
"No" )
Attached is a PBIX file to assist.
Theo 🙂
