https://community.fabric.microsoft.com/t5/s/yrjkf47658/tracker bobert523 Tracker Sat, 19 Sep 2026 18:11:10 GMT 2026-09-19T18:11:10Z https://community.fabric.microsoft.com/t5/Desktop/Combine-queries-with-conditions/m-p/2337367#M843413 <P>Hello- thank you for your suggestion.&nbsp; I tried that, but get "Token Literal expected" on the Pricing[Loc#] step.</P> Mon, 14 Feb 2022 15:50:43 GMT https://community.fabric.microsoft.com/t5/Desktop/Combine-queries-with-conditions/m-p/2337367#M843413 bobert523 2022-02-14T15:50:43Z https://community.fabric.microsoft.com/t5/Desktop/Combine-queries-with-conditions/m-p/2337226#M843369 <P>I have two tables - one with order data and one with pricing data.&nbsp; I want to combine the pricing data query to the order data so I can pull in the new price against historical order data.</P><P>&nbsp;</P><P>Order Data-</P><P>Cust #</P><P>Loc #</P><P>Item #</P><P>Order Qty</P><P>&nbsp;</P><P>Price Data-</P><P>Cust #</P><P>Loc #</P><P>Item #</P><P>Order minimum for price (same UOM as Order Qty in Order Data), but would use a &lt;=&nbsp;</P><P>Price per unit</P><P>&nbsp;</P><P>Having an issue pulling in the correct price based on quantity.</P> Mon, 14 Feb 2022 14:58:15 GMT https://community.fabric.microsoft.com/t5/Desktop/Combine-queries-with-conditions/m-p/2337226#M843369 bobert523 2022-02-14T14:58:15Z