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.
- Switching Relationships Dynamically in DAX ( Download)
- DAX for Power BI - Dynamic Relationship by Selection ( Download)
- DAX CALCULATE Trick to Pass Filters from Many to One Side of Relationship ( Download)
- Changing inactive relationship to active relationship using DAX in Power BI ( Download)
- Using SWITCH True Logic In Power BI - DAX Concepts ( Download)
- Changing Measures and Title Dynamically in Power BI - DAX Tips ( Download)
- How to use USERELATIONSHIP to handle MULTIPLE DATES in Power BI / DAX Basics 2021 ( Download)
- Handling MULTIPLE fact tables in Power BI ( Download)
- Measures vs. calculated columns in DAX and Power BI ( Download)
- Dynamically Switch X-Axis using DAX | Alternate Approach for Parameter in Power Bi | Unpivot Table ( Download)
- Related and RelatedTable in DAX ( Download)
- Working with Slowly Changing Dimensions in Power BI ( Download)
- DAX Basics: Filter CONTEXT & Calculate | Power BI Part 1 #PowerBI #design #shorts ( Download)
- Dynamic X and Y Axis in Power BI visuals Yes please! ( Download)
- Learn how a small model change and DAX helped to develop dynamic and scalable cohort analysis ( Download)
