Forum Discussion
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...
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 _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
