topic Re: Return value in Column 2 if column 1 is equal to ... in DAX Commands and Tips

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

sean123 — Thu, 01 Feb 2024 16:21:18 GMT

Hello,

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.

Thank you,
Sean

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

barritown — Thu, 01 Feb 2024 19:34:15 GMT

Hi 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

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

sean123 — Fri, 02 Feb 2024 08:03:07 GMT

Thank you Barritown, worked lovely!

All the best,
Sean