Forum Discussion

electrobrit's avatar
electrobrit
Icon for Post Patron rankPost Patron
3 years ago
Solved

Multiple conditions

I am trying to get a table where I have standard working hours, Total PTO, Adjusted Hours (Std hours-PTO), then a final column where if the resource type is "Contractor" or a specific person, ex. "An...
Need Help
  • Dinesh_Suranga's avatar
    Dinesh_Suranga
    3 years ago

    electrobrit 

    Hi

    Try this.

    Column 2 =IF(SELECTEDVALUE(TimeDetail[full_name])= "Andy", [TotalHoursWorked],
              IF(SELECTEDVALUE(TimeDetail[ResourceType]) = "Contractor", [TotalHoursWorked],[AdjustedHours]))

    Thnak you.

     

Dinesh_Suranga's avatar
Dinesh_Suranga
Icon for Continued Contributor rankContinued Contributor
3 years ago

electrobrit 

Hi

Try this.

Column 2 =IF(SELECTEDVALUE(TimeDetail[full_name])= "Andy", [TotalHoursWorked],
          IF(SELECTEDVALUE(TimeDetail[ResourceType]) = "Contractor", [TotalHoursWorked],[AdjustedHours]))

Thnak you.

 

electrobrit's avatar
electrobrit
Icon for Post Patron rankPost Patron
3 years ago

added as a measure in the key measures table and worked perfectly. THANK YOU