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
id | name |
101 | RAJA |
102 | RAM |
103 | KUMAR |
104 | JOHN |
105 | JOTHI |
106 | VIMALA |
login data
ID | DATE | IN OUT |
101 | 20-03-2023 | IN |
101 | 21-03-2023 | IN |
102 | 20-03-2023 | IN |
102 | 20-03-2023 | |
103 | 21-03-2023 | IN |
i need help,
i want name list of absent,
if the employee dont have "IN" in ( login data in out column) then emloyee absent
i tryd but not get correct answer
empmaster data
Solved! Go to Solution.
Hi @rajasekar_o
@amitchandak Good share!
I have provided other ways to solve this problem, please try the following operations:
Here's some dummy data
"login data"
"Table"
Create a measure. Determine whether there is an absence in the record:
IN_OUT =
IF(
SELECTEDVALUE('login data'[IN OUT]) <> "IN",
1,
0
)
Create a measure. Find the list of absentees:
Name =
var _id =
CALCULATE(
SUM('Table'[id]),
FILTER(
ALL('login data'),
[IN_OUT] = 1
)
)
RETURN
CALCULATE(
MAX('Table'[name]),
FILTER(
'Table',
'Table'[id] = _id
)
)
Here is the result:
If you're still having problems, provide some dummy data and the desired outcome. It is best presented in the form of a table.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @rajasekar_o
If my answer is correct, please mark it as accept as solution.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @rajasekar_o
@amitchandak Good share!
I have provided other ways to solve this problem, please try the following operations:
Here's some dummy data
"login data"
"Table"
Create a measure. Determine whether there is an absence in the record:
IN_OUT =
IF(
SELECTEDVALUE('login data'[IN OUT]) <> "IN",
1,
0
)
Create a measure. Find the list of absentees:
Name =
var _id =
CALCULATE(
SUM('Table'[id]),
FILTER(
ALL('login data'),
[IN_OUT] = 1
)
)
RETURN
CALCULATE(
MAX('Table'[name]),
FILTER(
'Table',
'Table'[id] = _id
)
)
Here is the result:
If you're still having problems, provide some dummy data and the desired outcome. It is best presented in the form of a table.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@rajasekar_o , Please find the attached file after signature,
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 |
---|---|
87 | |
83 | |
82 | |
67 | |
49 |
User | Count |
---|---|
135 | |
111 | |
100 | |
65 | |
62 |