Forum Discussion
DAX help
I have a list of employees who are working in different projects on daily basis. I need to check the count of employees working in projects for each month. If a emp is working in a project for 3months then include in count .
| Time | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug |
| Project 1 | Project 1 | Project 1 | Project 1 | Project 1 | Project 1 | Project 1 | Project 1 | |
| Emp | Yes | Yes | Yes | No | No | Yes | Yes | Yes |
| Count | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 |
I need to do it for every project and all employees
2 Replies
Saranya_Tamil , refer if my video on the same topic can help
Power BI- Customer Purchasing in each of the last 3 months: https://youtu.be/bGtjoccEA38
Saranya_Tamil it would be good if you could also provide some sample data.
