Forum Discussion
Solved
Conditional merge in Power query Excel
Hello friends, I'm new in this subject, so hopefully, someone will be able to help me out with my issue. What I'm looking for is the conditional merge in Power Query Excel. Here is the situation...
Hi Flixg
You can add a custom column to shipment table with below code. The sample file has been attached at bottom.
let vShipment = [Cust_ttl_SHipmnt] in Table.Column(Table.SelectRows(#"Discount Table", each [L_bound] <= vShipment and [U_bound] >= vShipment), "%Discount"){0}Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi Flixg
You can add a custom column to shipment table with below code. The sample file has been attached at bottom.
let vShipment = [Cust_ttl_SHipmnt] in Table.Column(Table.SelectRows(#"Discount Table", each [L_bound] <= vShipment and [U_bound] >= vShipment), "%Discount"){0}
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.