Comparing data from one table to the other and adding column

Hi Prashiyer ,

You’re on the right track! What you want is basically a VLOOKUP-like operation in Power BI/DAX to pull the Operation_Area from Dept_table into your IN_Data table based on matching Dept_Name.

In DAX, the most straightforward way is to use the RELATED function, but for that, you first need to set up a relationship between your two tables (IN_Data[Dept_Name] to Dept_table[Dept_name]) in the Power BI model. Once that’s ready, you can add a calculated column to IN_Data like:

Operation_Area = RELATED(Dept_table[Operational_Area])

If you can’t (or don’t want to) use relationships, you can use LOOKUPVALUE like this:

Operation_Area = LOOKUPVALUE( Dept_table[Operational_Area], Dept_table[Dept_name], IN_Data[Dept_Name] )

This will pull the right Operation_Area for each Dept_Name in your main table, just like Excel’s VLOOKUP.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
translation and formatting supported by AI