Grouping Consecutive dates as 1 entry

[android1]

Hi,

I have the table below which shows dates people were off sick. Problem is there is no Start & End date, just one continous date.

So if someone is off e.g 04/05/06 ie 3 consecutive days then this is 1 entry. 

I'd like to show how many times someone was sick rather than how many days. 

Below pic hopefully makes it clearer.

[v-yuezhe-msft · Accepted solution]

@android1,

Please check if the DAX in the following pbix file works.

https://1drv.ms/u/s!AhsotbnGu1NolB5o0Fh0J0Jdo1f-

Regards,
Lydia

[n00b_90]

Hi,

I’m dealing with the exact same problem. Is the solution available somewhere? The file on one drive is not accessible.

/M

[judspud]

Im having a similar issue. is this file still available? It says it may have been moved/deleted

[android1]

Hi Lydia,

Thanks for the feedback. Getting some unexpected results.

https://www.dropbox.com/s/spvmubg2w8bvzni/Sick%20Leave%20WIP.pbix?dl=0

[android1]

Hi @v-yuezhe-msft,

No, you're solution was perfect. Thank you very much for your work. Excellent.