harman1213
New Member
i have 2 data model in power bi-1 Formatted Orders data model i have 3 column Shipping State ,Grand Total and Carrier.
2 Courier pricing data model i have column name Regions AR is header contains name of Regions A2 to a27 and similarly i have carrier name in header from b1 to m1 and it contain pricing in b2 to m27 of all carrier according to region motioned in column A.
No i want to pull data from Courier pricing table to formatted order 1st it will check Grand total in formatted order is not blank, then it will match Shipping State from formatted order with Regions in Courier pricing and then it will match Carrier from formatted order with header (B1 to M1) of Courier pricing and return me the price of carrier. I am attaching here sample file for your reference.
2 Courier pricing data model i have column name Regions AR is header contains name of Regions A2 to a27 and similarly i have carrier name in header from b1 to m1 and it contain pricing in b2 to m27 of all carrier according to region motioned in column A.
No i want to pull data from Courier pricing table to formatted order 1st it will check Grand total in formatted order is not blank, then it will match Shipping State from formatted order with Regions in Courier pricing and then it will match Carrier from formatted order with header (B1 to M1) of Courier pricing and return me the price of carrier. I am attaching here sample file for your reference.