USERELATIONSHIP in DAX to manage multiple active and inactive relationships in Power BI!
🔥 Learn how to manage your DAX calculations to interact between multiple relationships using USERELATIONSHIP!
► We'll see how to create a data model containing multiple relationships between a sales table and a date table. We'll handle managing active and inactive relationships through a simple example.
► Finally, we'll create measures in DAX using the USERELATIONSHIP and CALCULATE functions.
📢 My newsletter where I break down the latest data news and share my tips to boost your skills 🚀👇👇
https://dataseito.substack.com/
👉 To become Power BI PL-300 certified, check out my practice tests: https://www.udemy.com/course/pl-300-m...
00:00 - Introduction
00:12 - Data presentation and import
00:56 - Creating a data model
01:30 - Active and inactive relationships in Power BI
03:30 - DAX measures with USERELATIONSHIP
My networks
► Contact me: / claudioanfuso
► More Exclusive content: / dataseito
🌐 Data: https://docs.google.com/spreadsheets/...
🌐 Creating a good data model: • Créer Un DATA MODEL Power BI Étape Par Étape
🌐 CALCULATE function in DAX: • CALCULATE Fonction DAX : Comment l'Utilise...
#USERELATIONSHIP #DAX #PowerBI #relationships
A tutorial in French by @Dataseito
P.S.: SUBSCRIBE 🔥 It's the best way to keep up! to improve 😉