cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
android1 Member
Member

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

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

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.
4 REPLIES 4
Moderator v-yuezhe-msft
Moderator

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.
android1 Member
Member

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

 

android1 Member
Member

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
judspud Member
Member

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

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 429 members 4,188 guests
Please welcome our newest community members: