Power BI Data Model & DAX using INACTIVE Relationship to Compare Data across Multi or Two Periods

Pubblicato il: 29 marzo 2024
sul canale di: Lighthouse Analytix

1,163

Step by step tutorial to create Power BI Data Model and DAX to efficiently compare data across multi periods.

This is a follow up video from last week, where I have shared TWO methods to compare data across multi periods: using ACTIVE relationship & INACTIVE relationship.

In last week video, I primarily focused on Method 1 - ACTIVE relationship.

In this video, I will be focusing on Method 2 - INACTIVE relationship.
Method two is a little bit tricker to understand... however, it does have 1 distinct advantage, such that you don't have to modify your original DAX, which may be referencing the original Date 1 or Date 2 table. You simply add on to your model, a new set of DAX, which references Date 3 table.

Hope you find this video useful... See you next time...

Cheers,
Isabella Susilowati
‪@LighthouseAnalytix‬
#PowerBI, #powerbitutorial, #powerbitutorialforbeginners

Time stamps
00:16 Recap from last week
02:05 Method 2
02:10 Step 1 - Copy Date Table
03:01 Step 2 - Create Inactive Relationship
03:22 Step 3 - Create Sales Measures
08:02 Step 4 - Create Table & Waterfall
08:27 Step5 - 3 Period Comparison
10:31 Epilogue

Royalty Free Music: Bensound.com/royalty-free-music
License code: FRLSO94CEK6IEFSV

LA124b

In questa pagina del sito puoi guardare il video online Power BI Data Model & DAX using INACTIVE Relationship to Compare Data across Multi or Two Periods della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Lighthouse Analytix 29 marzo 2024, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 1,163 volte e gli è piaciuto 42 spettatori. Buona visione!

4,093