Need Help!!!!

[TheLegendTamer]

Hi everyone.

I am having some issues bringing a date into a card into BI.

Basically, I have a date column which gets updated randomly (around once a week) I have a column with the latest date in as that is simple (lastdate function) However, I want last but one date in the column and every measure i have tried, it comes up with the day before the last date when there is no data in there for that date.

Example: - Last date is currently 13/08/2018. Previous date before that is currently 10/08/2018. How do I bring in this date. I thought it would be like lastdate - last date -1 or previous day function but nothing works.

Can someone help please..

Thank you

[rajulshah · Accepted solution]

Hello @TheLegendTamer,

Hopefully below link will help you going in the similar direction.

https://community.powerbi.com/t5/Desktop/How-to-get-previous-row-value-for-text-column/td-p/312560

Hope this works.

Regards.

[TheLegendTamer]

YES RAJULSHAH!! Nice one dude!