Forum Discussion
How to link data from other table
1) Load your 2 tables in power bi and "Unpivot" the date Columns in the "monthly unit price for products".
you should have a table like this:
2) Then you can Create a new Column mergin the "Product Number" and the "Date" in both tables
3) Then you can link the 2 tables with the new column you have just created
4) Write the following measure for Revenue=
SUMX('Units Forecast','Units Forecast'[Units]*RELATED(Prices[Value]))
Resolver III
1) Load your 2 tables in power bi and "Unpivot" the date Columns in the "monthly unit price for products".
you should have a table like this:
2) Then you can Create a new Column mergin the "Product Number" and the "Date" in both tables
3) Then you can link the 2 tables with the new column you have just created
4) Write the following measure for Revenue=
Solved. Thanks so much for your help😁
