Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DAX: DATEDIFF for blank values

I have a column called "Last Activity", which shows the date of the last activity. I created an additional column called "Days Since Last Activity" = datediff('Table'[Last Activity], today(), day) ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    Anonymous 

    pls try this

    = if(isblank('Table'[Last Activity]),9999,datediff('Table'[Last Activity], today(), day))

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
5 years ago

Anonymous 

pls try this

= if(isblank('Table'[Last Activity]),9999,datediff('Table'[Last Activity], today(), day))