Inner Joining and getting data on the basis of where clause.

[basim]

I have two tables in which one table field is primary key and another is foreign key.

I want apply inner join and want new table in which i need to get column from the second table on the basis of  the value first table column. 

How to do in Power BI ? Please define step by step.

[basim]

How to do below Query and below result in Power BI ?

SELECT LT.LT_NAME,LTV.LT_VALUE_TEXT from [WSS_Content_EPM_PWA].[pjpub].[MSP_LOOKUP_TABLES] LT
inner join [WSS_Content_EPM_PWA].[pjpub].[MSP_LOOKUP_TABLE_VALUES] LTV
ON LT.LT_UID = LTV.LT_UID
WHERE LT.LT_NAME = 'supporting technology department'

[ImkeF · Accepted solution]

In the query editor: https://www.excelguru.ca/blog/2015/12/23/merge-tables-using-inner-and-anti-joins-in-power-query/ 

or https://www.youtube.com/watch?v=BV3srtI20Bo

with DAX: https://www.youtube.com/watch?v=6Ew602P-aCk

[vrundasanghvi]

What if I want to retrieve only field? How do I achieve that using DAX. SQL equivalesnt would be: SELECT SALARY FROM EMPLOYEE SALARY E1 INNER JOIN EMPLOYEE E2 ON E1.EMPLOYEE_ID = E2.EMPLOYEE_ID. How do I achieve this? 

Salary is what I want to retrieve. Can you help?