Forum Discussion

vcaldeira's avatar
vcaldeira
New Member
5 years ago

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 !!



1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    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.