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

Published: 29 March 2024
on channel: 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

On this page of the site you can watch the video online Power BI Data Model & DAX using INACTIVE Relationship to Compare Data across Multi or Two Periods with a duration of hours minute second in good quality, which was uploaded by the user Lighthouse Analytix 29 March 2024, share the link with friends and acquaintances, this video has already been watched 1,163 times on youtube and it was liked by 42 viewers. Enjoy your viewing!

2,666