Forum Discussion
How to return value from a column based on sprcific value from another column, otherwise shows blank
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
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 !
3 Replies
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 !could you pls provide the sample data and expected output?
