Is there a way to have dynamically have only 5 weeks in a separate calculated table?
I have one fact table, one Date Dim. I am trying to create a calculated table which will have values of only 5 week dates as per the selection made in Date Dim. If I click one date value in the Date Dim, this calculated table should bring values of 5 week dates past to that selected dates.
Main need is, We are trying to see Top 5 products with past 5 week's status of the same product. User will select the week as parameter, the result should display the status of the products for past 5 weeks from the selected week.