Forum Discussion
Helper IVReplace 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 getting.
Active Employee
terminated Employee
New Joiner Employee.
It's a bit complicated as I use date slicer.
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))
1 Reply
- amitchandak
Super User
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))