My goal is to create a calculated Column (or Table) with logic that is able to assign a Table's Group a Hierarchy (unique) ID if the group name is = to an existing customer name, so that it is possible to link to all project/customer names. Since customers and projects all have the same hierarchy ID, it would be easy to link licensing information and customer information together this way. What function would be appropriate for this when 2 different tables and columns are involved?
• 'Licensing'[AccountName (groups)]
• 'License List'[Customer Name]
• 'License List'[Hierarchy ID]