Forum Discussion
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, Qty = total qty in Actual Table
BP get from BP table
Compare = % QTY- BP
pls help me. thanks alot
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.
2 Replies
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.
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.
