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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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