Comparing TREATAS vs USERELATIONSHIP in Power BI

preview_player
Показать описание
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:

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? *****
  1. Enterprise DNA
  2. Power BI
  3. Power BI DAX
  4. Enterprise DNA
  5. Sam Mckay
  6. Power BI Tutorial
Рекомендации по теме
Comparing TREATAS vs 0:07:36

Comparing TREATAS vs USERELATIONSHIP in Power BI

CALCULATE in DAX 0:04:18

CALCULATE in DAX #10: Using TREATAS

Avoid relationships using 0:11:51

Avoid relationships using TREATAS DAX function // Beginners Guide to Power BI in 2021

USERELATIONSHIP - DAX 0:02:10

USERELATIONSHIP - DAX Guide

USERELATIONSHIP Function in 0:05:53

USERELATIONSHIP Function in DAX

What is TREATAS 0:07:29

What is TREATAS DAX function and how to use it in Power BI? | DAX Sundays | BI Consulting Pro 4K

DAX Fridays #212: 0:06:36

DAX Fridays #212: Using inactive relationships in slicers | USERELATIONSHIP

Power BI DAX 0:08:28

Power BI DAX Tutorial (16/50) - What is TREATAS Function

TREATAS - DAX 0:03:45

TREATAS - DAX Guide

USERELATIONSHIP in calculated 0:26:05

USERELATIONSHIP in calculated columns

Using USERELATIONSHIP to 0:12:04

Using USERELATIONSHIP to Activate Inactive Relationships

Relationship DAX Functions 0:14:40

Relationship DAX Functions in Power BI | USERLATIONSHIP And CROSSFILTER DAX Function

How to use 0:08:39

How to use USERELATIONSHIP to handle MULTIPLE DATES in Power BI / DAX Basics 2021

Treatas DAX in 0:07:56

Treatas DAX in Power BI | Unrelated Tables

RELATED vs. LOOKUPVALUE 0:06:46

RELATED vs. LOOKUPVALUE DAX in Microsoft POWER BI | Power Pivot in Excel

Propagating filters using 0:19:18

Propagating filters using TREATAS in DAX

'D for DAX' 0:28:03

'D for DAX' - Part 4.2 - Userelationship, Lastdate and Treatas functions with Quiz and ans...

Getting Better at 0:10:10

Getting Better at DAX: Understanding TREATAS() Function

UseRelationship DAX in 0:04:51

UseRelationship DAX in Power BI - TAIK18 (6-26) Power BI

Power BI - 0:09:50

Power BI - How to handle Multiple Dates | Active Inactive Relationships | UseRelationship

TREATAS function to 0:02:13

TREATAS function to handle missing relationship in the model - 45 (Power BI Training)

When to use 0:08:30

When to use MERGE or RELATIONSHIP in Power BI // Beginners Guide to Power BI in 2020

ALL vs ALLSELECTED 0:00:10

ALL vs ALLSELECTED in Power BI | PowerBI Desktop | Power BI Tutorial

Logged-in User Vs. 0:05:50

Logged-in User Vs. All - in Power BI ⚡️| Compare Current User Vs others in - Power BI 😲

Комментарии
Автор

Very good comparison. In general I am interested in performance on this topic. Which topics need a lot of performance and which ones save performance?

RavenRock
Автор

Any benefit to using one or the other as far as performance/load time?

jbbaxter
Автор

Great video Jarrett, anyway to have the Power BI file so I can see and keep as a reference ?

erictremblay
Автор

At the end which one is better in performance?

MAbdullah
Автор

So TREATAS also works when there are relationships, by the looks of it.

RichardOliver