Forum Discussion
PBI perform inner or outer join
Hello everyone, I would like to aks you about data modeling in Power BI. If I choose my tables set like star schema at model I dont understand how to set inner join or outer join. If I will be speci...
Hello Anand24, I am sorry, but I think the issue was solved, but a had applied an filter to distinctcount 😞 If I have set both-directional join, the non matching values are still here :(.
And what makes you choose a bidirectional join?
It is from Anand post. Is It not right?
I feel you just need to join Dim table to Fact table on period_key with uni-directional filtering.
Ondrej
No, he suggested unidirectional.
Ok, but I am a little bit lost.. so I set up the join back to one direction? But I can not change the direction of filter, it is always from dates dimension to transport fact table (1:Many). Could you please share some screenshots?