Forum Discussion
Measure for data from 2 different tables
I have a table containing forecasts per month, per customer per product and a table containing actual sales per day, per customer, per product. My goal is to create summarized bar charts that show which 5 customers for example have more sales than forecasted, or which products where bought more than forecasted. I assumed that I would need a measure for this, however since this is between 2 different tables I don't know where to start and where to put the measure?
2 Replies
LudiaHelper I
Hi, first of first, the measure doesn't need to be in any table, but based on your description, I think you need to create the relationship for these 2 tables (by customer, or by product, please verify it based on your data granularity
After that, you can create a measure or 2 measure to achieve it easily, if you need, I can help more on it
Cheers
- amitchandak
Super User
Anonymous,
You need to have a common customer. If you do not have one create like
Customer = distinct(union(all(sales[customer]),all(forecast[customer])))
