Hello Community DAX function.

[mahendrapal1792]

I am sharing the table screenshot where there are column name date and hire date so I am trying to get the tenure day through that but I am not able to understand the logic of the calculated Dax formula for this, I am sharing the formula can someone explain me this that how this logic work     

TenureDays = IF([date]-[HireDate]<0,[HireDate]-[date],[date]-[HireDate])

I used this formula but i don't get the logic behind of it

[smpa01 · Accepted solution]

@mahendrapal1792  can you try this

Tenure Days = CONVERT(IF([date]-[HireDate]<0,[HireDate]-[date],[date]-[HireDate]),INTEGER)

[v-jialongy-msft · Accepted solution]

Hi @mahendrapal1792 

smpa01’s answer is correct , Since your original formula subtracts two dates and returns a date type, you need to use the convert function to make it an integer type.

There is another method you can use to get the same result.

You can use the DATEDUFF function, this function returns the number of units (unit specified in Interval) between the input two dates.

The formula is as follows

TenureDays = DATEDIFF([data],[HireData],DAY)

^{Best Regards,}

^Jayleny

[smpa01 · Accepted solution]

@mahendrapal1792  can you try this

Tenure Days = CONVERT(IF([date]-[HireDate]<0,[HireDate]-[date],[date]-[HireDate]),INTEGER)

[mahendrapal1792]

Can you explain how this formula works?