Forum Discussion
Lookup value for same day last month
Hi Anonymous ,
Please refer to my .pbix file.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super UserAnonymous As a best practice, add date dimension in your model and use it for and time intelligence calculations. Once the date dimension is added, mark it as a date table on table tools.
https://perytus.com/2020/05/22/create-a-basic-date-table-in-your-data-model-for-time-intelligence-calculations/
question is what you want to do when the current month is 31 days and the previous month is 30 days??
although you can use EDATE DAX function to get the previous month, same date.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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.⚡
i did use edate function to get the 'same day last month' but now I want to use this to lookup to date value and retrieve the attemps and success rates this day, how can I do that?