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")Sort of like
But it doesnt work
Thanks
Thanks