Replace from date to empty

[tebtim19]

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 getting.

Active Employee

terminated Employee

New Joiner Employee. 

It's a bit complicated as I use date slicer. 

[amitchandak · Accepted solution]

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