Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to Solution.
Hi,
Please try to create this calculated column in 'Empolyee' table first:
Column = DATEDIFF(RELATED(Contractor[Hire Date]),Employee[Hire Date],DAY)
Then try this color measure:
Color = IF(MAX(Employee[Column])=MINX(FILTER(ALL(Employee),Employee[Column]>=0),Employee[Column]),"#FF0000")
Apply this measure to the 'Employee'[Name] field, the result shows:
See my attached pbix file.
Best Regards,
Giotto
Hi,
Please try to create this calculated column in 'Empolyee' table first:
Column = DATEDIFF(RELATED(Contractor[Hire Date]),Employee[Hire Date],DAY)
Then try this color measure:
Color = IF(MAX(Employee[Column])=MINX(FILTER(ALL(Employee),Employee[Column]>=0),Employee[Column]),"#FF0000")
Apply this measure to the 'Employee'[Name] field, the result shows:
See my attached pbix file.
Best Regards,
Giotto
Create a common employee name dimension. Now take date diff from both tables and use that to do conditional formatting
refer how to take date diff
For highlight : https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
@Anonymous
Try the below-calculated column
StatusCheck =
var _contractHireDate=LOOKUPVALUE(ContractorTable[Hire Date],ContractorTable[Name],EmployeeTable[Name])
var _hireDate= EmployeeTable[Hire Date]
var _result= IF(ISBLANK(_contractHireDate),"Not Present in Contractor Table",IF(_hireDate>_contractHireDate,"Employee hire date is greater than contractor hire date","Employee hire date is less than contractor hire date"))
return _result
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
@nandukrishnavs hi im getting a error that "A table of multiple values was supplied where a single value was expected." for this dax measure
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |