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

Publicado em: 29 Março 2024
no canal de: 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

Nesta página do site você pode assistir ao vídeo on-line Power BI Data Model & DAX using INACTIVE Relationship to Compare Data across Multi or Two Periods duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Lighthouse Analytix 29 Março 2024, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 1,163 vezes e gostou 42 espectadores. Boa visualização!

2,666