return prev row

vcaldeira — Sat, 17 Oct 2020 01:33:10 GMT

Good night ! I would like to return as in this example the previous date of the cities. I have no idea how to resolve this issue Thank you !!

Re: return prev row

amitchandak — Mon, 19 Oct 2020 04:08:51 GMT

vcaldeira , no column headers, No data in text format. What is the input and output. Nothing is clear.

You can have formula like

maxx(filter(Table, [city] =earlier([city]) && [date] < earlier([date])),[date])

if this did not work

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.