Forum Discussion
Anonymous
2 years agoNot applicable
Power query- Key Number for the records
Hi All, I need to give number for each record of ACE_VALUE column I have concatenated 3 columns and created AC_VALUE column and i want to see key number like below example in a newly created cust...
- 2 years ago
Hi Anonymous
You can duplicate the table and remove duplicates :Add an index column :
And merge the tables:
The table that merged can be unchecked from loading to the model
pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly