Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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 formul...
Need Help
  • uzuntasgokberk's avatar
    uzuntasgokberk
    1 year ago

    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 |

rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
1 year ago

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.