Forum Discussion
Slicer related issues
The requirement is to have resource availability on a project. The data shows the project name, project start date and project roll off date. I would like to see the availability of resources when they are rolled off from a project. For example, if someone is rolled off from a project on june 2023 then from june 2023 they should show as available resource unless they are assigned on another project
Hi salonibajaj0211 ,
I created some data:
Here are the steps you can follow：
1. Create calculated table.
Table 2 = CALENDAR( DATE(2023,1,1), DATE(2023,12,31))2. Create measure.
Flag = var _year=SELECTEDVALUE('Table 2'[Year]) var _month=SELECTEDVALUE('Table 2'[Month]) var _projectmaxdate= MAXX( FILTER(ALL('Table'),'Table'[project name]=MAX('Table'[project name])),[project roll off date]) return IF( YEAR(_projectmaxdate)=_year && MONTH(_projectmaxdate) <=_month,1,0)3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
3 Replies
- amitchandak
Super User
salonibajaj0211 , Create a measure like an active employee in the given example and then plot a measure like beow against month/date/period from date table
Countx( project, if(isblank([Active Project]), project[ID], blank()) )
Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970 Hi salonibajaj0211 ,
I created some data:
Here are the steps you can follow：
1. Create calculated table.
Table 2 = CALENDAR( DATE(2023,1,1), DATE(2023,12,31))2. Create measure.
Flag = var _year=SELECTEDVALUE('Table 2'[Year]) var _month=SELECTEDVALUE('Table 2'[Month]) var _projectmaxdate= MAXX( FILTER(ALL('Table'),'Table'[project name]=MAX('Table'[project name])),[project roll off date]) return IF( YEAR(_projectmaxdate)=_year && MONTH(_projectmaxdate) <=_month,1,0)3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hey, just to an addition..
I have one more column Fte that represent the employee consumption on any project.
If the Fte has less than 1 as value, he is somehow available for few hours for any project. I want that employee to be also visible
