Calculated Column for Date Codes with Blanks

[TBaldwin11]

I have two date columns that I am attempting to find the difference between. The issue is that about 1/3rd are missing at least one date. Would like the calculated column to zero out the whole formula instead of subtracting from 01/01/1900 the way it currently is.

What I get:

Start Date 1	Start  Date 2	Difference Between
05/02/2025	05/17/2025	15
04/28/2025		-4689
	05/22/2025	4698

What I want:

Start Date 1	Start  Date 2	Difference Between
05/02/2025	05/17/2025	15
04/28/2025		0
	05/22/2025	0

Any suggestions on how to do this with Calculated Columns?

[uzuntasgokberk · Accepted solution]

Hello @TBaldwin11 ,

You can change the measure like this:
"
measure =
IF( ISBLANK([start_date2]) || ISBLANK([start_date1]), 0, [start_date1] -[start_date2])
"

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |

[TBaldwin11]

Perfect. Thank you very much.

[rajendraongole1]

Hi @TBaldwin11  - Yes, you can create a calculated column in Power BI using DAX that returns 0 if either of the two dates is missing, and otherwise returns the correct date difference.

Hope this helps. 

Please find the attached pbix file FYR.