Forum Discussion

tebtim19's avatar
tebtim19
Icon for Helper IV rankHelper IV
5 years ago
Solved

Replace from date to empty

Is there anyway I can replace my data from blank,  I have a terminate date which is set to 5555.12.31 for permanent employees and I want to replace that data to blank so I don't have any problem get...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

tebtim19 , In DAX a new column

T date = if([termination date] = date(5555,12,31), blank(), [termination date])

 

and use

 

or use this formula with my blog

 

Current Employees = CALCULATE(COUNTx(FILTER(Employee,Employee[Start Date]<=max('Date'[Date]) && (Employee[End Date] = (5555,12,31) || Employee[End Date]>max('Date'[Date]))),(Employee[Employee Id ])),CROSSFILTER(Employee[Start Date],'Date'[Date],None))

 

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970