Forum Discussion
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.
How can I achieve it the best way in Power BI?
Thanks for your time.
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/
3 Replies
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/
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
