Forum Discussion

togsoo1's avatar
togsoo1
Frequent Visitor
3 years ago

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 ...
Data Protection
togsoo1's avatar
togsoo1
Frequent Visitor
3 years ago

 

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-msft's avatar
    v-yanjiang-msft
    Community Support
    3 years ago

    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.