Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
sean123
Frequent Visitor

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

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. 

 

sean123_0-1706804340963.png

Thank you,
Sean

 

1 ACCEPTED SOLUTION
barritown
Super User
Super User

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 )

barritown_0-1706816040148.png

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian

View solution in original post

2 REPLIES 2
sean123
Frequent Visitor

Thank you Barritown, worked lovely!

All the best,
Sean

barritown
Super User
Super User

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 )

barritown_0-1706816040148.png

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors