Forum Discussion
DAX evaluate previous date based on unsequential random dates
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.⚡
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.⚡
Hi . The issue I have is that it seems to aggregate all sales less than the max date where I only need it for 2020/10/22, seems to include 2020/08/31 as well. It should evaluate the column and determine from the array of dates presented what would be considered the previous date from the latest date so not sure if "<" would work?