Forum Discussion

abhishekpati86's avatar
abhishekpati86
Helper III
9 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
    9 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
Microsoft Employee
9 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
Helper III
9 years ago

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