CONNECTION

[ngocnguyen]

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, Qty = total qty in Actual Table

BP get from BP table

Compare = % QTY- BP

pls help me. thanks alot

[Anonymous · Accepted solution]

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]

@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.