cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DevadathanK Resolver I
Resolver I

Data for 'Calculating productivity of Staff from Working hours, Holidays and Leaves'

 

Hi everyone,

 

I could'nt paste all the tables in the previous message due to the character limit.

This is the remaining data in question for my post  'Calculating productivity of Staff from Working hours, Holidays and Leaves'

https://community.powerbi.com/t5/Desktop/Calculating-productivity-of-Staff-from-Working-hours-Holida...

 

3. Leave Report

Staff NameStaff No.Leave StartDateLeave EndDate
Thomas Elliot10009/03/202003/04/2020
Dilo Brown10225/03/202025/03/2020

 

4. Holiday List

LocationHolidayDateDay
Kochi/ TrivandumGood Friday 10/04/2020Friday
Kochi/ TrivandumVishu14/04/2020Tuesday
Kochi/ TrivandumMay Day 01/05/2020Friday
Kochi/ TrivandumId-Ul-Adha/ Bakri Id31/07/2020Friday
Kochi/ TrivandumThiruvonam31/08/2020Monday
Kochi/ TrivandumGandhi Jayanthi02/10/2020Friday
Kochi/ TrivandumVijaya Dasami26/10/2020Monday
Kochi/ TrivandumChristmas25/12/2020Friday
BangaloreMakara Sankranthi15/01/2020Wednesday
BangaloreUgadi24/03/2020Wednesday
BangaloreMay Day 01/05/2020Friday
BangaloreVaramahalakshmi31/07/2020Friday
BangaloreGandhi Jayanthi02/10/2020Friday
BangaloreVijaya Dasami26/10/2020Monday
BangaloreBalipadyami/ Diwali16/11/2020Monday
BangaloreChristmas25/12/2020Friday
Mumbai, Pune & NagpurMakar Sankranthi14/01/2020Tuesday
Mumbai, Pune & NagpurHolI10/03/2020Tuesday
Mumbai, Pune & NagpurGood Friday 10/04/2020Friday
Mumbai, Pune & NagpurMaharashtra Day01/05/2020Friday
Mumbai, Pune & NagpurId-Ul- Aadha/ Bakriid31/07/2020Friday
Mumbai, Pune & NagpurAnant Chaturdashi01/09/2020Tuesday
Mumbai, Pune & NagpurGandhi Jayanthi02/10/2020Friday
Mumbai, Pune & NagpurChristmas25/12/2020Friday
MexicoNew Year's Day  01/01/2020Wednesday
MexicoConstitution's Day03/02/2020Monday
MexicoAnniversary Benito Juarez16/03/2020Monday
MexicoHoly Day09/04/2020Thursday
MexicoHoly Day10/04/2020Friday
MexicoLabor Day  01/05/2020Friday
MexicoMexican Independence Day16/09/2020Wednesday
MexicoMexican Revolution Day16/11/2020Monday
MexicoChristmas Day25/12/2020Friday
HungaryNew Year's Day  01/01/2020Wednesday
Hungary1848 Revolution Memorial Day15/03/2020Sunday
HungaryEaster Friday10/04/2020Friday
HungaryEaster Monday13/04/2020Monday
HungaryLabor Day  01/05/2020Friday
HungaryWhit Monday01/06/2020Monday
HungaryFoundation of State20/08/2020Thursday
HungarySt Stephen's Day21/08/2020Friday
Hungary1956 Revolution Memorial Day23/10/2020Friday
HungaryAll Saints Day01/11/2020Sunday
HungaryChristmas24/12/2020Thursday
HungaryChristmas Day25/12/2020Friday
HungaryChristmas26/12/2020Saturday
United StatesThanksgiving  28/11/2019Thursday
United StatesSample29/11/2019Friday
United StatesChristmas  25/12/2019Wednesday
United StatesSample26/12/2019Thursday
United StatesSample31/12/2019Tuesday
United StatesNew Year's Day  01/01/2020Wednesday
United StatesSample22/05/2020Friday
United StatesMemorial Day  25/05/2020Monday
United StatesSample02/07/2020Thursday
United StatesIndependence Day    03/07/2020Friday
United StatesSample04/09/2020Friday
United StatesLabor Day  07/09/2020Monday

 

Thank you for all the help! 

 

1 REPLY 1
Super User IV
Super User IV

Re: Data for 'Calculating productivity of Staff from Working hours, Holidays and Leaves'

This can use this for day level leave. You can use day level holiday to do rest of the calculation

CALCULATE(countx(SUMMARIZE(filter(CROSSJOIN('Table','DimDate'),'DimDate'[Date] >= 'Table'[AbsenceStartDate] && 'DimDate'[Date]<= 'Table'[AbsenceEndDate]),'Table'[id],'DimDate'[Date]),'DimDate'[Date]))

 





Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @
My Recent Blog -Week is not so Weak Proud to be a Super User! Connect on Linkedin


Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors