Forum Discussion

rishi11x's avatar
rishi11x
New Member
2 years ago

Missing values in table

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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!