Forum Discussion
How to join two tables in direct query
Hello, I have two tables: The first tables shows my orders and products which were ordered with a quantity and the second table shows all my available products without quantity field. So I want to...
- Try this:
VAR __Table =
NATURALINNERJOIN(
'Products',
SELECTCOLUMNS(
'Orders',
"SKU",[SKU],
"Quantity",[Quantity]
)
)
amitchandak
Super User
Super UserI am assuming product here is product dimension, Same way you have date dimension,
When you create sum of qty measure add +0
Qty Total = Sum(Table[Qty]) +0
Also, explore this option