Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi guys,
I am trying to see if employees are sick, on holiday or available at the office.
To do this I created two columns with "Status description" to determine if they are available or not
Column 1:
Column 2:
So, what takes precedence? If one column shows Available and one Away, which is it and what is it for all possible combinations of values?
@Greg_Deckler If they are either sick or on holiday they should be away.
So it should look something like:
Measure x = IF('AbsenceRegistrationTransaction'[StatusDescription] = "Away" ; "Away"; IF('LeaveRegistration'[StatusDescription] = "Away"; "Away"; "Available"))
Really hard to do this one without sample data or more specifics around what you want this to end up like. But, let's say you have a data slicer that you filter down to a specific date. And you have a table visual of employees, you might be able to do a measure like:
Measure =
VAR __EmployeeID = MAX('Employees'[EmployeeID])
VAR __Date = SELECTEDVALUE('Dates'[Date])
VAR __LeaveStatus1 = MAXX(FILTER('LeaveTable1',[EmployeeID] = __EmployeeID && [Date] = __Date),[LeaveStatus1])
VAR __LeaveStatus2 = MAXX(FILTER('LeaveTable2',[EmployeeID] = __EmployeeID && [Date] = __Date),[LeaveStatus2])
RETURN
<Implement your business logic here>
@Greg_DecklerThanks for helping me so far, but if I try your measure it will only return "Away" for one employee, not for the others.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
92 | |
86 | |
83 | |
66 | |
49 |
User | Count |
---|---|
140 | |
114 | |
108 | |
64 | |
60 |