Forum Discussion

kennyyip's avatar
kennyyip
Icon for Helper I rankHelper I
8 years ago
Solved

vlookup and return text

Hi,   I have two tables, one is raw data table ("Deal") and the other  table "Customer" is created by summarizing the table "Deal" using the key "customer name" (which is also text). Each customer ...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    kennyyip,

     

    You may refer to the DAX below.

    Column =
LOOKUPVALUE ( Deal[industry], Deal[customer name], Customer[customer name] )

    Table =
SUMMARIZE ( Deal, Deal[customer name], Deal[industry] )
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

When you say you create the Customer table by Summarizing the Deal table, how do you do this?  Do you do it in Power Query, as a calculated table or other?

kennyyip's avatar
kennyyip
Icon for Helper I rankHelper I
8 years ago

It's a calculated table using SUMMARIZE

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    kennyyip,

     

    You may refer to the DAX below.

    Column =
LOOKUPVALUE ( Deal[industry], Deal[customer name], Customer[customer name] )

    Table =
SUMMARIZE ( Deal, Deal[customer name], Deal[industry] )