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...
Anand24
Super User
Super UserHi ondrej-cdc ,
I feel you just need to join Dim table to Fact table on period_key with uni-directional filtering.
Now you just need to take the field from Dim table into slicer/filter. Non-matching values from Fact table would be automatically neglected in the slicer.
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! |