In this video, Sam shows how to work with multiple dates within an underlying fact table by using the USERELATIONSHIP function within CALCULATE through a common scenario that data analysts will most likely to encounter.
***** Video Details *****
00:00 Introduction
0:43 Data model
01:50 Natural filtering with the active relationship
03:38 USERELATIONSHIP
05:10 Common confusion with multiple dates
05:48 Conclusion
***** Learning Power BI? *****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE - Power BI Resources - enterprisedna.co/power-bi-resources
FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership - enterprisedna.co/membership
Enterprise DNA Online - portal.enterprisedna.co/
Enterprise DNA Events - enterprisedna.co/enterprise-dna-events-page/
#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial
- Handling Multiple Dates in Power BI With DAX [2022 Update] ( Download)
- Handling Multiple Dates in Power BI With DAX ( Download)
- DAX Fridays! #183: How to deal with multiple dates in Power BI ( Download)
- How to use USERELATIONSHIP to handle MULTIPLE DATES in Power BI / DAX Basics 2021 ( Download)
- Power BI - How to handle Multiple Dates | Active Inactive Relationships | UseRelationship ( Download)
- Dealing with Multiple Date Fields to bring values from same time period in Power BI | MiTutorials ( Download)
- Using Multiple Date Tables Power BI ( Download)
- Calculating Sales Financial Year To Date In Power BI With DAX [2022 Update] ( Download)
- Layering Multiple 'What If' Scenarios In Power BI - Advanced DAX Concepts [2022 Update] ( Download)
- The DATEADD Function - The Best and Most Versatile Time Intelligence Function In DAX [2022 Update] ( Download)
- Handling MULTIPLE fact tables in Power BI ( Download)
- How to get a DATE TABLE easily in Power BI ( Download)
- Handling Weekday vs Weekend Dates In Power BI Using DAX [2023 Update] ( Download)
- Power BI Basics Date slicer to filter on multiple date columns part 1 ( Download)
- Use DAX Relationship for Multiple Dates Columns ( Download)
