Forum Discussion

vilenm's avatar
vilenm
Helper II
5 years ago
Solved

DAX evaluate previous date based on unsequential random dates

Hi   I have a [Load Date] Column with 3 dates 2020/08/1, 2020/10/22,2021/01/13. What would be the dax I would use to determine the previous date from the latest date. I attempted Previous Date = CA...
  • parry2k's avatar
    5 years ago

    vilenm yes it should, if not then share sample data to look into it further. Test it out first and let's go from there.

     

    Check my latest blog post Compare Budgeted Scenarios vs. Actuals to get a summary of my favourite Power BI feature releases in 2020

    I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.