Return value in Column 2 if column 1 is equal to ...

Question

Hello,&nbsp;I wonder if you might be able to help. I am trying to work out a way in PowerBi to return the result in the yellow column below...such as...if the "type" is an employee return a value of zero but if the "type" is a contractor turn the value in the "hours" column.&nbsp;&nbsp;Thank you,Sean&nbsp;

barritown · Accepted Answer

Hi&nbsp;sean123,
It's an easy one - you can solve your case with a calculation column like this:
Contractor Hours = IF ( [Type] = "Contractor", [Hours], 0 )

Best Regards, 
Alexander
My YouTube vlog in English
My YouTube vlog in Russian

Forum Discussion

Return value in Column 2 if column 1 is equal to ...

2 Replies

Related content

Creating custom columns keeps returning a structured Table column

Create measure to return value from column when condition met for two other columns

Need column to return date in working days from today, from query table column.

New Column

Return Column Name if Zero Value