Forum Discussion
Using parameter table to make new column
Hi, I have a table Booking imported from an Excel file ID Code Memberschip Installment Commission 1 B 86,94 60,00 250,00 2 C 19,44 255,00 750,00 3 B 7,86 705,00 20...
The answers to almost all of your questions are to do with how you link to the other table from the 'many' side.
You have to use the RELATED function. The intellisense (autocompletion) is smart enough to give you only items that it thinks you can use according to the template of the functions you call.
hi,
you could also join the information as additional columns using power query - I like to do this for these cases
https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data
best regards,
florian