topic Re: Add a column from another table in Developer

Add a column from another table

Anonymous — Tue, 18 Apr 2023 13:18:47 GMT

Hello,

I've two tables: 'Positions' and 'Applicants'. I need to make a new visual table out of the two tables mentioned above. The difficulty here is that I want to combine position[estimatedate] and applicants[joiningdate] into a single column and add a filter to display next month information in the visual table.

I'm new to PowerBI and would appreciate any assistance.

Thanks in advance!

Re: Add a column from another table

rajulshah — Tue, 18 Apr 2023 13:33:53 GMT

@Anonymous
You can use RELATED or LOOKUPVALUE function to create a calculated column in any one of the tables and then you can create another calculated column in the same table using the 2 columns.

Re: Add a column from another table

Anonymous — Tue, 18 Apr 2023 13:54:01 GMT

Hai @rajulshah ,

Could you please give the reference code so that I can learn how to use DAX expressions?
I'm new to this technology and have just been using PowerBI for two weeks.

Re: Add a column from another table

rajulshah — Wed, 19 Apr 2023 11:00:34 GMT

@Anonymous , I didn't get you, can you please explain what do you mean by reference code?

Re: Add a column from another table

Anonymous — Mon, 24 Apr 2023 11:52:01 GMT

Hai @rajulshah,

I used RELATED it works perfectly - Thanks for your help 🙂

Re: Add a column from another table

rajulshah — Mon, 24 Apr 2023 13:03:17 GMT

@Anonymous Please mark as solution to help other users to find the answer.