Create a Calculated Column from Different Tables - PowerBI

[jak82]

Hi, I have two table (alot more but ill use two). In my ad details table 'addetails' I have a column called 'adqinstr' in there I have mulitple rows with either "Private", "Trade", or "Bus Acc".In my customer table 'custAcc' I have created a cacluated column where i want to say if find "Buss Acc" then set it to "BA" else put "normal". None of the DAX functions seem to be available (no list appears) and the useful columns only seem to show the columns for that table.
Sort of like ​

Column = If(Related('adDetails'[adqinstr])="Bus Acc","BA","Normal")

But it doesnt work

Thanks
​

 

[Scotland The Brave]

I think Power BI uses the same syntax/language that Power Query does. In a new calculating column Try:
= if [adqinstr] = "Bus Acc" then BA else Normal