Forum Discussion
electrobrit
3 years agoPost Patron
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. "Andy", it equals Hours Worked.
Otherwise, it's the Adjusted Hours
I have done most measures in a Key measures table. Then I have a detail table where I'm trying to do the conditional column (Contractor or Andy=hours worked, else Adjusted Hours) with the measures and detail.
I've tried
Column 2 = SWITCH(
TRUE(),
'TimeDetail'[full_name]="Andy"|| TimeDetail[ResourceType]="Contractor", SUMX('--Key Measures',[TotalHoursWorked]),
[AdjustedHours]
)
I've tried this and get same results
I've looked at the data and it's not the data, but some of the column values (conditonal column) are off.
In the screenshot, they should equal the total hours worked columnn
Is there another way to do this conditional column or can anyone tell what might be wrong?
I've tried this and get same results
Column 2 = SWITCH(
TRUE(),
TimeDetail[ResourceType]= "Contractor", [TotalHoursWorked],
TimeDetail[full_name]= "Andy", [TotalHoursWorked],
TimeDetail[ResourceType]= "Employee", [AdjustedHours])
I've looked at the data and it's not the data, but some of the column values (conditonal column) are off.
In the screenshot, they should equal the total hours worked columnn
Is there another way to do this conditional column or can anyone tell what might be wrong?
Hi
Try this.
Column 2 =IF(SELECTEDVALUE(TimeDetail[full_name])= "Andy", [TotalHoursWorked],
IF(SELECTEDVALUE(TimeDetail[ResourceType]) = "Contractor", [TotalHoursWorked],[AdjustedHours]))Thnak you.
2 Replies
- Dinesh_SurangaContinued Contributor
Hi
Try this.
Column 2 =IF(SELECTEDVALUE(TimeDetail[full_name])= "Andy", [TotalHoursWorked],
IF(SELECTEDVALUE(TimeDetail[ResourceType]) = "Contractor", [TotalHoursWorked],[AdjustedHours]))Thnak you.
- electrobritPost Patron
added as a measure in the key measures table and worked perfectly. THANK YOU