topic Re: How to link data from other table in DAX Commands and Tips

How to link data from other table

CarolLoveRabbit — Thu, 15 Dec 2022 10:53:58 GMT

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 — Thu, 15 Dec 2022 11:14:46 GMT

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 — Fri, 16 Dec 2022 05:34:31 GMT

Solved. Thanks so much for your help😁