Comparing Treatas Vs Userelationship In Power Bi

Here's a video showing you the difference between TREATAS and USERELATIONSHIP when creating DAX measures. I will go over the process of when and why we use each of those DAX functions.

Here are the links mentioned in the video:
Two Fact Tables For Same Dates Table - forum.enterprisedna.co/t/two-fact-tables-for-same-dates-table/10377
TREATAS Function - info.enterprisedna.co/dax-function-guide/treatas/
USERELATIONSHIP Function - info.enterprisedna.co/dax-function-guide/userelationship/

Jarrett

***** Video Details *****
0:42 Enterprise DNA Forum query on two fact tables
1:16 TREATAS definition
1:37 USERELATIONSHIP definition
2:09 data model used with the fact table and date table
3:15 when to use TREATAS function
4:47 when to use USERELATIONSHIP function

***** 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/

  • Comparing TREATAS vs USERELATIONSHIP in Power BI ( Download)
  • Avoid relationships using TREATAS DAX function // Beginners Guide to Power BI in 2021 ( Download)
  • CALCULATE in DAX #10: Using TREATAS ( Download)
  • USERELATIONSHIP - DAX Guide ( Download)
  • USERELATIONSHIP Function in DAX ( Download)
  • Relationship DAX Functions in Power BI | USERLATIONSHIP And CROSSFILTER DAX Function ( Download)
  • What is TREATAS DAX function and how to use it in Power BI | DAX Sundays | BI Consulting Pro 4K ( Download)
  • Power BI DAX Tutorial (16/50) - What is TREATAS Function ( Download)
  • Getting Better at DAX: Understanding TREATAS() Function ( Download)
  • Using USERELATIONSHIP to Activate Inactive Relationships ( Download)
  • How to use USERELATIONSHIP to handle MULTIPLE DATES in Power BI / DAX Basics 2021 ( Download)
  • DAX Fridays #212: Using inactive relationships in slicers | USERELATIONSHIP ( Download)
  • USERELATIONSHIP in calculated columns ( Download)
  • TREATAS - DAX Guide ( Download)
  • Propagating filters using TREATAS in DAX ( Download)