Forum Discussion
spartan27244
Resolver I
Resolver ICreating a BETWEEN relationship
We have a calculated column on many of our tables to convert a date to an integer that represents the year and month in which that item ocurred. For example a date of service for a medical claim (DOS...
parry2k
Super User
Super Userspartan27244 not fully followed your question, 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/
Use this date table to set the relationship and derive the logic.
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.⚡