Forum Discussion

Colinu's avatar
Colinu
Icon for Helper I rankHelper I
8 years ago
Solved

Day Count from Last date in Record

Hi All   I am new to BI and would like some help please.    My data has a date colum that shows the last visit to a location. I have used the new mesure (Lastdate) to find the record with the mos...
Need Help
  • p0nk's avatar
    p0nk
    8 years ago

    Try this measure:

     

    Date difference = DATEDIFF(LASTDATE(Table Name[Date of Visit]), TODAY(), DAY)

  • Anonymous's avatar
    Anonymous
    8 years ago

    Colinu,

    If your issue is solved, please accept appropriate replies as answer to close this thread.

    Regards,
    Lydia

p0nk's avatar
p0nk
Frequent Visitor
8 years ago

Try this measure:

 

Date difference = DATEDIFF(LASTDATE(Table Name[Date of Visit]), TODAY(), DAY)

  • Colinu's avatar
    Colinu
    Icon for Helper I rankHelper I
    8 years ago

    That's what i needed thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Colinu,

      If your issue is solved, please accept appropriate replies as answer to close this thread.

      Regards,
      Lydia