none
DAX: Time intelligence and filtering out blank values

    Question

  • Hi all,

    Quick question.  I'm currently calculating the length of time between two dates ('today' vs [Completed Date]) in a new column.  However, I cannot get the syntax correct to filter out the blanks in the [Completed Date] column.

    My current formula is this:  =FLOOR(1. * ( today() - [Completed Date]) / 365, 0.25)

    I just need one more piece to work around the blanks.  Any suggestions on what to add?

    Thanks,

    ~UG

    Wednesday, February 12, 2014 6:00 PM

Answers

  • Use ISBLANK
    =IF (ISBLANK([Completed Date]),BLANK(),FLOOR(1. * ( today() - [Completed Date]) / 365, 0.25))


    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    • Marked as answer by undergrads1 Wednesday, February 12, 2014 6:13 PM
    Wednesday, February 12, 2014 6:06 PM

All replies

  • Use ISBLANK
    =IF (ISBLANK([Completed Date]),BLANK(),FLOOR(1. * ( today() - [Completed Date]) / 365, 0.25))


    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    • Marked as answer by undergrads1 Wednesday, February 12, 2014 6:13 PM
    Wednesday, February 12, 2014 6:06 PM
  • That's it!  Thank you, Visakh. 

    ~UG

    Wednesday, February 12, 2014 6:13 PM
  • You're welcome

    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    Wednesday, February 12, 2014 6:19 PM