Forum Discussion

jayjay0306's avatar
jayjay0306
Icon for Helper III rankHelper III
2 years ago
Solved

lookup through multiple tables

Hi people, I hope you can help me with a challenging task in making a calculated table in Power BI: I have a data model loooking like this: My challenge is an effort to make a calculated tab...
@Dax help
calculated table
DAX
Power BI Desktop
  • Jihwan_Kim's avatar
    Jihwan_Kim
    2 years ago

    Hi, I am not sure if I understood your question correctly, but if your target to create the calculated table that looks like above, please check the below picture and the attached pbix file if it suits your requirement. It is for creating a new table.

     

     

    New Table =
ADDCOLUMNS (
    F_Sales,
    "@Product Name", RELATED ( D_Product[Product Name] ),
    "@Customer Name", RELATED ( D_Customer[Customer Name] )
)

     

     

     

     

     

jayjay0306's avatar
jayjay0306
Icon for Helper III rankHelper III
2 years ago

off course jiwhan_Kim, thanks 🙂