Conditional Formating within 2 different queries

[Yashh]

Greetings,

I have 2 columns in data table in power BI from different tables .

• Available Stock
• Ordered Quantity                                                                                                          

I want to use the conditional formatting for the following.

• If Ordered Quantity is more then Available stock then No 
• If Else Yes.

to be returned back .

I tried merging but it is not of use because there are similar material numbers .

[Arul]

@Yashh ,

Could you share the sample data?

Thanks,

Arul

[Yashh]

@Arul  

First Query which contains material number and available quantity

Second query which contains the ordered quantity. But here you can see there are material repeated so we cannot use the merge option.