Forum Discussion
Filtring two tables by date
Hi everyone,
I am trying to filter two tables with date . I made a diagram to explain
I try to use the function Add request on Power Query or try something in relation page but I have no result for making a filter between these 2 tables. Thanks for all help ! 🙂
4 Replies
- Idrissshatila
Super User
Hello togsoo1 ,
You should try creating a date dimension and link it to both and then filter by it.
check this out https://zebrabi.com/advanced-guide/how-to-create-a-date-dimension-table-in-power-bi/
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Hello Idrissshatila thank you very much for your answer, i try it but for my Number of Data 1 its not filtrering ( i not forget to make type of data : DATE)
v-yanjiang-msftCommunity Support
Hi togsoo1 ,
According to the snapshot you provided, there're three tables, we can't create active relationships between each other. In other words, we can create a closed-loop relationships. The filter is not working is because the relationship is inactive(dotted line).
If you want Requete table filter IW69 and IW39 tables but the relationship between IW69 and IW39 can't be deleted, you should change the relationship direction between IW69 and IW39 to both.
Best regards,
Community Support Team_yanjiang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-yanjiang-msft , Hello, thank you for your reply. Unfortunately, despite the change of direction for the relationship, the dotted line relationship is still not changeable to active.
my file : https://drive.google.com/drive/folders/114uhiiehKb3jLKnb_KQTIuhD8SDrZHpF?usp=sharing
