Forum Discussion
Dim Date created how to joining with multiple dates
Hi Experts,
Please can you clarify me a doubt
DIMDate created using M or Dax is linked in the data model to say
DimDate - -> One to many to FactAssessment - > DatePublished
But I have so many dates in the system, like DateAdvt, DateAssessed, DateIvited etc.
Please can you help me understand how to make this join,
Thanks a lot
Anonymous you can create join on all columns with your dimdate table, one relationship will be active and others will be inactive, to use an inactive relationship, use the USERELATIONSHIP function in your measures.
Check the YT playlist on the Date dimension here Time Intelligence (DAX) - Power BI - YouTube
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort 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.
2 Replies
- parry2k
Super User
Anonymous you can create join on all columns with your dimdate table, one relationship will be active and others will be inactive, to use an inactive relationship, use the USERELATIONSHIP function in your measures.
Check the YT playlist on the Date dimension here Time Intelligence (DAX) - Power BI - YouTube
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort 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.
Thanks a lot parry2k .. Much appreciated