Forum Discussion

Post Patron

8 years ago

Solved

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.

Anonymous
8 years ago
android1,

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

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

Regards,
Lydia

5 Replies

Anonymous
Not applicable
8 years ago
android1,

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

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

Regards,
Lydia
- judspud
  Solution Supplier
  7 years ago
  Im having a similar issue. is this file still available? It says it may have been moved/deleted
- android1
  Post Patron
  8 years ago
  Hi Lydia,
  
  Thanks for the feedback. Getting some unexpected results.
  
  https://www.dropbox.com/s/spvmubg2w8bvzni/Sick%20Leave%20WIP.pbix?dl=0
  - android1
    Post Patron
    8 years ago
    Hi Anonymous,
    
    No, you're solution was perfect. Thank you very much for your work. Excellent.
- n00b_90
  Frequent Visitor
  6 years ago
  Hi,
  
  I’m dealing with the exact same problem. Is the solution available somewhere? The file on one drive is not accessible.
  
  /M