Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 wh...
Help Requested
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

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])))