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
Slightly modify your measure to the following:
3 RSO Sent in 3 Days = IFERROR ( IF ( VALUE ( Tracker[Ageing - JO IN to RSO] ) <= 3 && VALUE ( Tracker [No. of RSO Sent] ) >= 3 , "Yes" , "No" ) , 0 )
So all you are doing is wrapping your existing measure with IFERROR ( [existing measure] , 0 ) which says if there's an error, then just return a 0. If you want it to be blank, then just change the 0 to BLANK() like below:
3 RSO Sent in 3 Days = IFERROR ( IF ( VALUE ( Tracker[Ageing - JO IN to RSO] ) <= 3 && VALUE ( Tracker [No. of RSO Sent] ) >= 3 , "Yes" , "No" ) , BLANK() )
Hope this helps!
Theo 🙂
syaHelper I
Helper IHi Theo,
I tried the formula that u shared but it results in the following:
And the formula doesn't suggest columns that are already in the table, but only suggested my other created measures to be in the formula.
Sya
- TheoC
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 🙂