Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

4 REPLIES 4
Mariusz
Community Champion
Community Champion

Hi @Anonymous 

 

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

 

Anonymous
Not applicable

@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!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
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...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.