Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 calculate based on a specific date which products were ordered and which not.
Problem: How can I merge a table with quantity and the table without quantity. All products without quantity should get the value zero.
I can do that with an join using import modus but how to do the merge in direct query? Just need some ideas 🙂
Thank you in advance. Best regards.
Solved! Go to Solution.
I 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
You can't merge in Direct Query, you would need to edit the source system.
You could theoretically merge them in DAX using things like NATURALINNERJOIN, etc. but that will be part of a measure calculation.
@Greg_Deckler Thank you for your fast reply. So I tried to do a join but I get the error message "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value." On the picture I tried to describe what I want to create but is this even possible since the tables have different columns?
Hi,
Try this
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |