Please find my workaround attached.
there is a limitation to show the product which doesn't have value for the selected period, but has value for previous period, this can't be display. If you need this as well, I will suggest you to reshape your data structure.
Current-Previous_v10.2.twbx 16.2 KB
I would like to pass the time period filter to other sheets which i have in the dashboard, which i can't do with the lookup function.
Can you please suggest if you have any other solution.