question

DenisseSantana-0344 avatar image
0 Votes"
DenisseSantana-0344 asked LeonLaude edited

Assigning existing Unique IDs to a Table that does not have these IDs using DAX? Power BI

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]



not-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

LeonLaude avatar image
0 Votes"
LeonLaude answered

Hi @DenisseSantana-0344,

Please note that Power BI is currently not supported in the Q&A forums, the supported products are listed over here https://docs.microsoft.com/en-us/answers/products.

You may ask the experts in the dedicated Power BI forum over here:
https://community.powerbi.com/t5/Forums/ct-p/PBI_Comm_Forums


If the reply was helpful please don't forget to upvote and/or accept as answer, thank you!


Best regards,
Leon

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.