Forum Discussion
Counting sick days into occurences
Hi i have search for this answer already but cant find anything on it In power BI, how would I make a table like this: Employee Sick Date Hours 123456 29/9/23 6 123456 ...
Hi ZealandZu ,
You can refer the following links to try to find the solution:
Solved: Calculating total number of sick days this month - Microsoft Fabric Community
Solved: Calculating sick days - Microsoft Fabric Community
If the above ones can't help you get the expected result, could you please provide the specific examples to explain every requirement? Thank you.
Best Regards
These dont help as my issues is due to the fact that if someone is ill on a friday and subsequently still off ill on the monday also, that would be classed as only one occurence still whereas all the links you provided dont take that into account. As for specific requirement, im not sure how to ask it in a different way that isnt already in my original post. Sorry