Forum Discussion
time filter creation
Sol 1:
You can use role-playing dimensions
Have 2 similar calendar tables - 1st connected to offer date and 2nd connected to option date
Then you can use two different date hierarchies on 2 different tables to filter your analysis.
Refer more on https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
Sol 2:
If its a fairly small report then you can think of merging the two tables and creating a single table architecture.
This could be an optimum way if you evaluate using dax studio on how much cpu consumption your queries take.
Here's a video which helped me evaluate the architecture - https://www.youtube.com/watch?v=qEWrYO1ioe0
Did I answer your question? Mark my post as a solution!
Appreciate your Kudos!! Happy to Help! Katerina_SL
Thank you for reply! I will check video.
Regarding 1st solution, I think I will not able to use it because I need to have these 2 measures in one table and at the end have the sum of them. That's why I can't use 2 different filters.
I was thinking maybe it's possible to include this somehow into function for these measures. But I don't have idea how to do it.