Forum Discussion

pstanek's avatar
pstanek
Icon for Post Patron rankPost Patron
10 years ago

Products with zero numbers

I have  two tables in direct query list of products and stock. Relation Stock->Product I need to calculate list of products that I don´t have in stock. Problem is that I have written only products...
Need Help
Show and Tell
pstanek's avatar
pstanek
Icon for Post Patron rankPost Patron
10 years ago

I am not sure .IT is MS AZURE

 

 

You  have information what you have, but I need to find rest of products. It means what you have not-- in order to buy it .

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

pstanek

 

In this scenario, you can use "Merge Queries" to combine those two tables. If there's no match data from second table, it will return null.

Then you can create a calculated column like:

IF(Table[column]=BLANK(),0,Table[column])

Regards,