Missing values in table

[rishi11x]

Hi, 

I have a main table that populates values based on matching ID from another table. Table 2 contains a list of error codes which are used to populate the same in Table 1 that has a summary of each error that occured. For some reason, some of these values are coming up as blank in Table 1. 

Table 1: Missing value next to code 22002703

Table 2: containing data for error code 22002703

[Anonymous]

Hi @rishi11x 

How did you bring the description data into Table 1? Using DAX or Power Query?

If you want to use DAX to create a new column, you can try

Desc Column =
MAXX (
    FILTER ( 'Table2', 'Table2'[almcdCode] = 'Table1'[elAlarm] ),
    'Table2'[almcdDescription]
)

If you want to use Power Query, you can use Merge Queries feature. 

If some values are still missing, please check if there is any potential leading/trailing spaces in the cells in Power Query Editor. Trim the columns in advance. 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[Fowmy]

@rishi11x 

Use merge queries to get the missing vales.

Can you share some sample data with the desired output to have a clear understanding of your question?