Forum Discussion
Katerina_SL
Helper II
2 years agotime filter creation
Hello everyone! I would like to ask help regarding creating filter. I have 2 table. Table 1 contain: Offer Time of Offer Creation Table 2 contain: Offer (connection with table1) Opt...
Bijen_Shah
2 years agoRegular Visitor
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