Forum Discussion

abhishekpati86's avatar
abhishekpati86
Icon for Helper III rankHelper III
10 years ago
Solved

Getting the value from the excel sheet for 2 different columns and rendering it in power BI

Here is the requirement. I have the below matrix from a dataset containing some text values in End User Trade Name.     The 3rd column contains a score and it is set to 1 for a selected grou...
Need Help
Show and Tell
  • v-yulgu-msft's avatar
    v-yulgu-msft
    10 years ago

    Hi sridevi,

     

    Because there doesn’t exist any relationshipbetween two tables, to return the value from Keyword_Trade_Name table, you need to join these two tables:

    crossjoinTbl = ADDCOLUMNS(CROSSJOIN(Keyword_Trade_Name,Table_Test),"match value",IF(FIND(Keyword_Trade_Name[Trade_Name],Table_Test[End User Trade Name],,0)>0,Keyword_Trade_Name[value],0))

     

    Select columns from this new table to add to table visualization.

     

    If you have any question, please feel free to ask.

     

    Best regards,
    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Hi sridevi,

 

Because there doesn’t exist any relationshipbetween two tables, to return the value from Keyword_Trade_Name table, you need to join these two tables:

crossjoinTbl = ADDCOLUMNS(CROSSJOIN(Keyword_Trade_Name,Table_Test),"match value",IF(FIND(Keyword_Trade_Name[Trade_Name],Table_Test[End User Trade Name],,0)>0,Keyword_Trade_Name[value],0))

 

Select columns from this new table to add to table visualization.

 

If you have any question, please feel free to ask.

 

Best regards,
Yuliana Gu

abhishekpati86's avatar
abhishekpati86
Icon for Helper III rankHelper III
10 years ago

v-yulgu-msft -- It seems to work perfectly. Thanks for providing a workaround.