cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper III

## Name list of absent

 id name 101 RAJA 102 RAM 103 KUMAR 104 JOHN 105 JOTHI 106 VIMALA

 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

1 ACCEPTED SOLUTION
Community Support

@amitchandak Good share!

I have provided other ways to solve this problem, please try the following operations:

Here's some dummy data

"Table"

Create a measure. Determine whether there is an absence in the record:

``````IN_OUT =
IF(
1,
0
)``````

Create a measure. Find the list of absentees:

``````Name =
var _id =
CALCULATE(
SUM('Table'[id]),
FILTER(
[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.

3 REPLIES 3
Community Support

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.

Community Support

@amitchandak Good share!

I have provided other ways to solve this problem, please try the following operations:

Here's some dummy data

"Table"

Create a measure. Determine whether there is an absence in the record:

``````IN_OUT =
IF(
1,
0
)``````

Create a measure. Find the list of absentees:

``````Name =
var _id =
CALCULATE(
SUM('Table'[id]),
FILTER(
[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.

Super User

@rajasekar_o , Please find the attached file after signature,

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors