Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
vickyprudhvi
Helper IV
Helper IV

Writing DAX for Slowly changing dimension Type 2 table

Hi,

Below is the 2 tables

1) AdjusterHierarchy Table

2) ClaimRoot Table (fact). type 2

 

When we pull adjuster Field against 3PointDays total for ClaimRootEffectDateID as 09/03/2008

it should show details only or

ABC as 51

EDF as 60

But I am not able get that instead I am getting BCD as 29 too which is not right.

Kindly help pls

 Doubt_1.jpg

 

0 REPLIES 0

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.