Forum Discussion

CarolLoveRabbit's avatar
CarolLoveRabbit
New Member
3 years ago
Solved

How to link data from other table

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's avatar
    Uspace87
    3 years ago

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

     

     

     

     

     

     

2 Replies

  • Uspace87's avatar
    Uspace87
    Icon for Resolver III rankResolver III
    3 years ago

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