Extract Value from one column based on Value of another.

[tim-hammond]

Greetings - This is a really simply one for you guys - not so simple for me being a rank amateur....

I would like to make a new column or measure that takes a value out of one column based on the context of another and changes it by 0.5

Above is where i am - what i wish to do is filter Call Machine by SCHEDULED CALL and echo the value of Site Time [in this case 8] into the column 'SLA less travel' and MINUS 0.5 [30 mins] so the end result it this example will be 7.5 where it currently says true.

Thank you very much in advance!

Tim

[tim-hammond]

[konstantinos]

@tim-hammond You can try 

SLA less travel =
IF (
    'APRIL Remote Time'[[Call_Machine] = "Schedule Call";
    'APRIL Remote Time'[Site Time] - 0,5;
    'APRIL Remote Time'[Site Time]
)

If is "Schedule call" it will return the value minus 0.5 and if not it will echo the value

[tim-hammond]

Thank you very much Konstantinos!

That is perfect - i edited it a bit as i need the SCHEDULED CALL time less 30 minutes so this is what i have now...

SLA less travel =
IF ('APRIL Remote Time'[Call_Machine] = "Scheduled Call",' APRIL Remote Time'[Site Time] - 0.5)

This will add to my crib sheet 🙂 Good Luck!

Tim

[konstantinos · Accepted solution]

You can try 

SLA less travel =
IF (
    'APRIL Remote Time'[[Call_Machine] = "Schedule Call";
    'APRIL Remote Time'[Site Time] - 0,5;
    'APRIL Remote Time'[Site Time]
)

If is "Schedule call" it will return the value minus 0.5 and if not it will echo the value