How to link data from other table

[CarolLoveRabbit]

Hi Team,

Need your help for this one. I have two tables as below.

Table 1: monthly units forecast. My painpoint is,

1. How can I get price from Table 2

2. How to calculate revenue once getting price

Table 2: monthly unit price for products

Thanks.

Br,

Carol Yan

[Uspace87 · Accepted solution]

@CarolLoveRabbit 

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

)

[CarolLoveRabbit]

Solved. Thanks so much for your help😁