Day Count from Last date in Record

[Colinu]

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 most recent visit and this displys in a table fine. What i need to do is show how many days have lapsed since this last visit.

Table looks like this:

Locations           Date of Visit

Office                  12-01-18

New Mesure is:

Date of Last Visit = Lastdate (Visits[Dateoflastvisit])

I need to return the value in Days as a number.

Hope you can help, thanks

[p0nk · Accepted solution]

Try this measure:

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

[p0nk · Accepted solution]

Try this measure:

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

[Colinu]

That's what i needed thanks

[v-yuezhe-msft · Accepted solution]

@Colinu,

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

Regards,
Lydia