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 bl...
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?