DAX Query

[Anonymous]

Hi All,

I have a data set similar to the below example. 

On Hire Date	Off Hire Date	Hire Duration (Days)
01/01/2020	10/01/2020	10
02/01/2020	10/01/2020	9

I want to create a DAX formula that will show me any rows that are above 10 days for instance.

Please can anyone help?

Many thanks,

E

[camargos88 · Accepted solution]

Hi @Anonymous ,

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

You could follow the way of @camargos88 to filter out in filter pane. Or you could use a IF function to implement it.

Please try this:

Measure = 
var diff = DATEDIFF(MAX('Table'[On Hire Date]),MAX('Table'[Off Hire Date]),DAY)+1
return
IF(diff>=10, diff)

[amitchandak]

@Anonymous , refer if this can help

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

or datediff([On Hire Date],[Off Hire Date],day)+1

[camargos88 · Accepted solution]

Hi @Anonymous ,