cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
dthuler Frequent Visitor
Frequent Visitor

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

Accepted Solutions
Super User
Super User

Re: Relationship on date between a date range

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.
3 REPLIES 3
Super User
Super User

Re: Relationship on date between a date range

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.
Community Support Team
Community Support Team

Re: Relationship on date between a date range

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.
dthuler Frequent Visitor
Frequent Visitor

Re: Relationship on date between a date range

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