cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Coan7
Post Patron
Post Patron

Count between from and to date

Hi, 

 

I need to show in a table/matrix the days someone is gone based on from and to date:
Dataset includes datetable.

 

The dataset looks somewhat like this (3 columns):
Person    from               to
1             03.02.2020     07.02.2020
2             04.02.2020      07.02.2020

Desired matrix:
Weeknr 6  
day                Mon   Tue    Wed    Thu   Fri    Sat  Sun
person 1        1          1        1         1        1           
person 2                    1         1         1        1        



 

 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

You want a modification of Open Tickets. https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/td-p/409364


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

View solution in original post

4 REPLIES 4
Mariusz
Community Champion
Community Champion

Hi @Coan7 

 

Please see the attached file with a solution in Power Query.

 

Table - you sample 

Table ( referenced ) - Table referenced to Table and Transformed to expand dates ( Added Colum step )

Calendar - list of dates + weekday column ( date dimension )

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

@Mariusz, nice solution with power query.

See dax solution by Greg_Dekler.

You want a modification of Open Tickets. https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/td-p/409364

Greg_Deckler
Super User
Super User

You want a modification of Open Tickets. https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/td-p/409364


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

View solution in original post

amitchandak
Super User
Super User

Refer this blog can help to deal with between date. Now instead of count of employee take sum of weekday

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.