Slicer related issues

[salonibajaj0211]

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

[Anonymous · Accepted solution]

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

[salonibajaj0211]

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

[amitchandak]

@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-tr...