How to return value from a column based on sprcific value from another column, otherwise shows blank

[Anonymous]

Hi. 

In my table, I have 2 column which is "Name" and "Task Detail". I want to create a new column which will show the name of employee who put "Task Detail" as Off. If not Off, the value will be blank. 

Thanks a lot

[JadhavVarsha_13 · Accepted solution]

Hi @Anonymous 

You can try below 

Click on new column and use this expression  

Column = IF(tbl_TableName[Task Detail]="Off",tbl_TableName[Name]," ")

Let me know if this helps !

[Anonymous]

it works. I was looking into more complex function such as LOOKUPVALUE, SUMMARIZE, GROUPBY... and it shows me errors

[ryan_mayu]

could you pls provide the sample data and expected output?