Dax to obtain Last Date, Result of Last Date, Second to Last Date, Result of Second to Last Date
Hi all, Hoping someone much smarter than me can help! Basically I have a table which is constantly being updated with more entries. There are many duplicate references which will have many resuls and visit dates. A snapshot of the data is below: As part of my analysis I want to compare the last 2 visits only (I want this to be dynamic so in a months time the data will change). I would like a table showing the columns like in the image below. Last Visit Date = The date the reference was visited last. Last Result = The Result of the Last Visit Second to Last Visit Date = The visit date before the last visit date Second to Last = The Result of the Second to Last Visit. No. of Days Difference = The number of days between the last and second to last visit. I managed to get a version of the Dates columns but I don't think it was ideal. I think the method I used is what's stopping me from getting the result which I also need. Anyone have any suggestions please? Thanks
