cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Solution Supplier

Continuous Attendance

Hi Everyone,

I have below table with employee attendance data from which I need to identify whether there is any employee who has reported to work continuously for 7 days or more. Pls help, may data look like this. Thank you inadvance !

 EMP No Date 1 9/17/2018 1 9/18/2018 1 9/19/2018 1 9/20/2018 1 9/21/2018 1 9/22/2018 1 9/23/2018 1 9/25/2018 1 9/26/2018 1 9/27/2018 1 9/28/2018 1 9/29/2018 1 9/30/2018 2 9/17/2018 2 9/19/2018 2 9/20/2018 2 9/21/2018 2 9/22/2018 2 9/23/2018 2 9/24/2018 2 9/25/2018 2 9/27/2018 2 9/28/2018 2 9/29/2018 2 9/30/2018 3 9/17/2018 3 9/19/2018 3 9/20/2018 3 9/21/2018 3 9/22/2018 3 9/24/2018 3 9/25/2018 3 9/27/2018 3 9/28/2018 3 9/29/2018 3 9/30/2018 4 9/17/2018 4 9/18/2018 4 9/19/2018 4 9/20/2018 4 9/21/2018 4 9/22/2018 4 9/23/2018 4 9/24/2018 4 9/25/2018 4 9/26/2018 4 9/27/2018 4 9/28/2018 4 9/29/2018 4 9/30/2018
1 ACCEPTED SOLUTION
Community Champion

@dilumd

Try this calculated column.

It will identify the first day when consecutive 7 days start for each employee

You can then use it as VISUAL filter

```Continuously_Present =
VAR mycontinuousdays = 7
RETURN
IF (
[Date] + mycontinuousdays
- 1
= CALCULATE (
MIN ( [Date] ),
FILTER (
Table1,
[EMP No] = EARLIER ( [EMP No] )
&& [Index]
= EARLIER ( [Index] ) + mycontinuousdays
- 1
)
),
"Present"
)
```

Regards
Zubair

2 REPLIES 2
Community Champion

@dilumd

Try this calculated column.

It will identify the first day when consecutive 7 days start for each employee

You can then use it as VISUAL filter

```Continuously_Present =
VAR mycontinuousdays = 7
RETURN
IF (
[Date] + mycontinuousdays
- 1
= CALCULATE (
MIN ( [Date] ),
FILTER (
Table1,
[EMP No] = EARLIER ( [EMP No] )
&& [Index]
= EARLIER ( [Index] ) + mycontinuousdays
- 1
)
),
"Present"
)
```

Regards
Zubair

Solution Supplier

Announcements

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors