Calculated Table Column, Difference between 2 dates, only when both are populated

[OobuJoobu]

I have a table that contains, among many others, fields called "DateScreened" and "DateOffered".

I need to create a new column ("Date Screeened to Date Offered") that shows the number of days between the 2 dates, but only when both are populated (it is not mandatory for either of these rows to be populated).

My new column is currently built like this:

Date Screened to Date Offered = [DateOffered] - [DateScreened]

It works perfectly when both dates are populated, but returns, for example, 44916 where the Date Screened is not populated (I understand why, I don't need that answering), I just need it to be blank where either date doesn't exist.

Anyone got a way to do this please?

[tackytechtom · Accepted solution]

Hi @OobuJoobu,

How about this:

Date Screeened to Date Offered = 
IF ( 
    OR ( ISBLANK ( [DateOffered] ), ISBLANK ( [DateScreened] )),
    BLANK(),
    [DateOffered] - [DateScreened]
)

Let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[tackytechtom · Accepted solution]

Hi @OobuJoobu,

How about this:

Date Screeened to Date Offered = 
IF ( 
    OR ( ISBLANK ( [DateOffered] ), ISBLANK ( [DateScreened] )),
    BLANK(),
    [DateOffered] - [DateScreened]
)

Let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[OobuJoobu · Accepted solution]

Absolutely perfect, thank you!

[nvprasad]

Hi,

You can try below DAX

Date Screened to Date Offered =  IF( [DateScreened] = BLANK(), BLANK(),[DateOffered] - [DateScreened])

Appreciate a Kudos! ‌‌
If this helps and resolves the issue, please mark it as a Solution! ‌‌

Regards,
N V Durga Prasad

[OobuJoobu]

Thank you, I expect that works perfectly, I've already tried the solution from @tackytechtom whch does the job lso.