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

Опубликовано: 29 Март 2024
на канале: Lighthouse Analytix
1,163
42

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