cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dthuler
Helper I
Helper I

Relationship on date between a date range

Hi Guys,

 

I am looking to link the two tables below to count the number of employees for a specific day or the daily evolution of the population. In a full year view, I am trying to count the number of peoples transactions per day. With Date as horizontal axis from 1. January to 31. December, null being assumed for a person if outside Report Start and End Limit boundaries in the report.

 

2018-08-06_10-21-31.png

 

How can I achieve it the best way in Power BI?

Thanks for your time.

1 ACCEPTED SOLUTION

I don’t understand what you are asking, but you ma find this article I wrote useful https://powerpivotpro.com/2016/12/how-many-working-days-has-an-employee-been-off-work/



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

3 REPLIES 3
v-yulgu-msft
Microsoft
Microsoft

Hi @dthuler,

 

Would you please share some dummy data to illustrate your requirement? Also, please show us the desired output.

How to Get Your Question Answered Quickly

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I don’t understand what you are asking, but you ma find this article I wrote useful https://powerpivotpro.com/2016/12/how-many-working-days-has-an-employee-been-off-work/



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

Hi Matt,

 

Sorry for the late reply. Thank you for your reply, it helped me to sort this out by looking it in a different way.

Your article helped me to understand the FILTER part better as well and I used it a different way to get it working.

 

Best Regards,
David

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.