Forum Discussion
How would create unique IDs for tracking for columns that will have duplicates?
I am trying to discover a way to find a way by resourceName (see link) to create some method of uniqueness given there are some duplicates in the resourceName columns as it's a weekly scan result. Wo...
HEllo Anonymous ,
you could add an index column in power query https://learn.microsoft.com/en-us/power-query/add-index-column
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
You can generate a unique value using a formula in the table. However, an ID must be a value, not a formula, so copy (Ctrl+C) and paste the result of the formula calculation as plain text (Shift+Ctrl+V) into the cell that should contain the new ID. That's all there is to it!