Forum Discussion

singupil's avatar
singupil
New Member
4 years ago
Solved

DAX - SCD logic

Hi Friends, I had one scenario in SSAS Tabular Model, where i have 2 objects. 1) SourceData Object - which is a SCD 2 Object where we track all the history for the changes 2) Dim Date Object I ne...
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi singupil ,

    According to your description, here's my solution.

    1.There's no relationship of the two tables.

     

    2.Create a measure in SourceData table.

    Check =
IF (
    SELECTEDVALUE ( DimDate[Date ] ) >= MAX ( 'SourceData'[Start Date] )
        && SELECTEDVALUE ( DimDate[Date ] ) < MAX ( 'SourceData'[End Date] ),
    1,
    0
)

    3.Put the measure to the visual filter and select 1.

    I attach my sample below for reference.

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi singupil ,

According to your description, here's my solution.

1.There's no relationship of the two tables.

 

2.Create a measure in SourceData table.

Check =
IF (
    SELECTEDVALUE ( DimDate[Date ] ) >= MAX ( 'SourceData'[Start Date] )
        && SELECTEDVALUE ( DimDate[Date ] ) < MAX ( 'SourceData'[End Date] ),
    1,
    0
)

3.Put the measure to the visual filter and select 1.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.