Retriving data of a column from a table to another table

[Turka89]

Hi Community,

I have 2 tables one is Requisition and another is Vacancy. Both have common and different columns also different data. a relationship is active via VacancyID 

There is a column exist only in Requisition called RequisitionNumber which is used to calculate the number of Requisitions.  I have used Division column to differentiate which requsition belong to.  

I have applied a measure called Total Requisition on both Tables. Please see below Screenshot

There are missing numbers of data from Requisition Table in VacancyID and Vacancy Title columns which cause the number of Requisition to fall down in Vacancy Table. Please see below Screenshot

If There are data in VacancyID and Vacancy Title assigned to Engineer Requisitions in Requisition table then numbers of Requsitions should be matched in both table.

In Vacancy Table you can find those missing Vacancies in Requisition table

I can't simply add those missing data to Requsition table. I need a way to retrive them rather adding them

Thank you in advance

[v-easonf-msft]

Hi , @Turka89 

You said that  "a relationship is active via VacancyID". Therefore, I am confused about another sentence you said: "Number of missing data in the request table in VacancyID and Vacancy Title". 

Could you please share  more details ,such as your sample data and desired output screenshots for further analysis?

You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

I am not sure what desired result would you want.If  you just  want to retrive data of a column from a table to another table,maybe you can take a try the function"lookupvalue" in calculate column:

VacancyID = LOOKUPVALUE(VacancyTable[VacancyID],VacancyTable[VacancyTitle],RequisitionTable[Title])

Best Regards,
Community Support Team _ Eason

[Turka89]

Hi @v-easonf-msft 

Thank you so much for taking the time to see what I am trying to achieve. 

I tried LOOKUPVALUE function and it didn't worked. I wasnt eable to retrive data that it doesn't exist in Vacancy Table from Requisition Table 

Please have a look at this Power Bi file which has the following data:

Req Table

Vac Table

What I would like to see is get retrive Req Titles based on Business unit to Vacancy table, or vice-versa. 

can this be achieved also by outerjoin?

Example.pbix 

Thank you