Average between two date columns

[SoundCheese]

Hello,

New to this, still muddling my way through learning. I have an issue i'm trying to solve.

I have been asked to retrieve some data:

Days to Hire  (For those with a date in the Hire (GO) column, what is the average days between the Date Column and the Hire (GO) column?)

Table with two date columns Hire (Go) and Hire.

What would be the best approch to this in a measure.

Thanks,

- Dane

[ankitpatira · Accepted solution]

@SoundCheese You can start by having a calculated column that gives you difference in days between two dates and then take the average out of that column. To get average number of days that took for hire you don't have to write any calculations you can just use visuals and Quick Calc feature to get average of the total of difference in days coumn. Check out this page and scroll down to Quick Calc explanation.