Forum Discussion
Conditional formatting matrix values based on other table column values
- Anonymous5 years ago
I got the answer. Thanks all for reading this. Here is what I did :
I created measure for selected date hired, selected date released for the employee in the context.
SelectedStaff = SELECTEDVALUE(table[table.employee]) to capture the staff in context
Selected Date Hired = CALCULATE(MIN(Employee[Employee.dateHired]),FILTER(Employee,Employee[Employee.displayName] = [SelectedStaff])) to capture the hired date of employee in context
Similar dax for date release. Finally created the outstanding flag with below formula:
Outstanding flag = IF([WeekDay- Weekend] = "Weekday" && [Selected Date] >= [Selected Date Hired] && [Selected Date] <= MAX(TODAY(),[Selected Date Released]) && [Available Hours new] >= [Selected Daily Hours] ,1,0)
Applied the conditional formatting through outstanding flag on the entered hours by rule. It worked
Anonymous , in this case, employee needs to there in visual (means in context), can you share what all you plan to have in the output table.