Switching Relationships Dynamically in DAX
It is important to have multiple relations between your transactions(facts) and your lookup(dimensions) and you can use the relations as per the circumstance for e.g., using your invoice date vs. payment date vs. order date. Different calculations are based on different dates, how would you change them without manually touching the entities?
In this video, we will see how you can switch within these relationships dynamically by using DAX.
This is very powerful and it can be used for a number of Finance use cases.
Watch video Switching Relationships Dynamically in DAX online without registration, duration hours minute second in high quality. This video was added by user DataExplained 19 April 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,156 once and liked it 11 people.