Interval Match and Changing Dimensions

[#1]

Hi All

I have a task where I need to build SCD charts. Problem is, I have two tables containing dates and do not have any fact table.

I have tried interval match but it does not work quiet the way I want it to.

Please see attached spreadsheet for the details and data and expected results. How should I approach this?

[sunilkumarqv]

Find the attached

[#3]

Hi Sunil

Thanks for the reply.

I want to have the exact same results in QV as the tables in the "Results" tab in the spreadsheet.