Forum Discussion
Comparing values between different tables
Ok. If you're using Power BI Desktop you just need to apply both your tables to the model, relate LIST to CONTAINER on CONTAINER[COD] 1 = * LIST[COD] (assuming your CONTAINER table contains a UNIQUE list of customers), then drag CONTAINER[COD] and LIST[VALUE] columns into a visual. PBI will automatically aggregate the result giving you what it sounds like you're after.
If this is to be done in Excel, then probably easiest to just do a merge in PQ instead of a relationship as described above in the model.
Pete
Use merge query in Power Query, or load the data into the model and use DAX to calculate (aggregate and then determine whether it is greater than 0).
Super UserHi 3mi81 ,
This looks like an XY Problem.
The real question is: Why do you want to create a summary table in Power Query for data you already hold (in the LIST table)? DAX is designed to handle aggregations like this in the data model, so what's the use-case of duplicating this data?
Pete