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 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

 

 

 

Need Help

2 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    2 years ago

    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?

  • 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!