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

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