Relationship on date between a date range

[Anonymous]

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.

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

Thanks for your time.

[v-yulgu-msft]

Hi @Anonymous,

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

[MattAllington · 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/

[Anonymous]

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