Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Power BI doesn't load Excel formulas properly

Hello,    I would like to ask a question related to Power BI or Queries Editor. I have a database in Excel with one large table. In this table, some of the columns consist of data or values and som...
Need Help
v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi Anonymous ,

 

If it only happened with INDEX MATCH function, We can try to create a calculated column after create relationship between two tables as a workaround:

 

 

Sales Channel = RELATED('Table 2'[Sales Channel])

 

 

 


If it doesn't meet your requirement, Could you please show the exact expected result based on the Tables that we have shared？

 


Best regards,