Showing results for 
Search instead for 
Did you mean: 
Helper IV
Helper IV

Writing DAX for Slowly changing dimension Type 2 table


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




Helpful resources

Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors