Forum Discussion
fact table startdate -enddate
I have a slowly changing dimension and a Fact Table Product Category StartDate EndDate P1 C1 01/01/2020 20/01/2020 P1 C2 21/01/2020 31/03/2020 P2 C3 01/01/2020 31/12/2099 ...
Well, with the sample data, you would do this:
Table2 Category = MAXX(FILTER('Table1'[Product] = 'Table2'[Product] && 'Table2'[Date]>='Table1'[StartDate] && 'Table2'[Date]<='Table1'[EndDate]),[Category])
Table2 Category = MAXX(FILTER('Table1'[Product] = 'Table2'[Product] && 'Table2'[Date]>='Table1'[StartDate] && 'Table2'[Date]<='Table1'[EndDate]),[Category])