Forum Discussion

Dunner2020's avatar
Dunner2020
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

Datediff when date column does not have default value

Hi there,   I have created a measure that calculates the difference between two dates columns (Date A and Date B). If there is no date present in Date A column, then by default it fills with the da...
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    6 years ago

    Dunner2020 , You should be able to use isblank for the blank date which 1899/12/31

    Also, you can not have "" and number together. Data type is different

     

    IF( isblank(MAX('Interruptions'[Date A])), 0, DATEDIFF(MAX('Interruptions'[Date B]),
    MAX('Interruptions'[Date A]), DAY))

    IF( isblank(MAX('Interruptions'[Date A])), blank(), DATEDIFF(MAX('Interruptions'[Date B]),
    MAX('Interruptions'[Date A]), DAY))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Dunner2020 , You should be able to use isblank for the blank date which 1899/12/31

Also, you can not have "" and number together. Data type is different

 

IF( isblank(MAX('Interruptions'[Date A])), 0, DATEDIFF(MAX('Interruptions'[Date B]),
MAX('Interruptions'[Date A]), DAY))

IF( isblank(MAX('Interruptions'[Date A])), blank(), DATEDIFF(MAX('Interruptions'[Date B]),
MAX('Interruptions'[Date A]), DAY))