The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to Solution.
@android1,
Please check if the DAX in the following pbix file works.
https://1drv.ms/u/s!AhsotbnGu1NolB5o0Fh0J0Jdo1f-
Regards,
Lydia
@android1,
Please check if the DAX in the following pbix file works.
https://1drv.ms/u/s!AhsotbnGu1NolB5o0Fh0J0Jdo1f-
Regards,
Lydia
Im having a similar issue. is this file still available? It says it may have been moved/deleted
Hi Lydia,
Thanks for the feedback. Getting some unexpected results.
https://www.dropbox.com/s/spvmubg2w8bvzni/Sick%20Leave%20WIP.pbix?dl=0
Hi @Anonymous,
No, you're solution was perfect. Thank you very much for your work. Excellent.