Forum Discussion

ngocnguyen's avatar
ngocnguyen
Helper IV
5 years ago
Solved

CONNECTION

hi, I have 2 input data like Actual and BP table below Now I wanna create a slicer : POL and POD  => If I choose slicer: POL = PKL, POD = HCM I can get the below results as Output table In which,...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi ngocnguyen ,

     

    The result is this.

     

    The method is to summarize all possible results of the Carrier, POL, and POD columns of the two tables into one table, and then map the values to the new table.

     

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

ngocnguyen If I understand correctly, you would create a 2 separate tables using an Enter Data query where you would have POL and POD values and then you relate those tables to your other 2 tables. You could also create these tables using DAX or Power Query.