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
30 мар 2024
