Reply
Member
Posts: 198
Registered: ‎04-04-2016
Accepted Solution

Grouping Consecutive dates as 1 entry

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.

 

2018-07-12 14_33_26-Sick Leave - Power BI Desktop.jpg


Accepted Solutions
Moderator
Posts: 9,577
Registered: ‎03-10-2016

Re: Grouping Consecutive dates as 1 entry

@android1,

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

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

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post


All Replies
Moderator
Posts: 9,577
Registered: ‎03-10-2016

Re: Grouping Consecutive dates as 1 entry

@android1,

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

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

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Member
Posts: 198
Registered: ‎04-04-2016

Re: Grouping Consecutive dates as 1 entry

Hi Lydia,

 

Thanks for the feedback. Getting some unexpected results.

 

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

 

Member
Posts: 198
Registered: ‎04-04-2016

Re: Grouping Consecutive dates as 1 entry

Hi @v-yuezhe-msft,

 

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

Highlighted
Frequent Visitor
Posts: 2
Registered: ‎10-24-2018

Re: Grouping Consecutive dates as 1 entry

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