Forum Discussion
return prev row
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 !!
amitchandak
Super User
Super Uservcaldeira , 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.