Forum Discussion
Calculated Column for Date Codes with Blanks
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?
Hello Anonymous ,
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 |
3 Replies
Hello Anonymous ,
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 |Hi Anonymous - 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.
