Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 custom column in power query
ACE_VALUE | Key Number |
123ABC22/3/24 | 1 |
123CDA3/5/2021 | 2 |
123ABC22/3/24 | 1 |
568CDA31/1/2007 | 3 |
123CDA3/5/2021 | 2 |
Please reply
Thanks!!
Solved! Go to Solution.
Hi @Bharathi_99
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
Hi @Bharathi_99
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
Happy to help 🙂
Hi @Bharathi_99 ,
Please refer to the screenshot below and measure.
If this post helps, please consider accept as solution to help other members find it more quickly.
Thanks,
Hari R
Hi @Shreeram04 Thanks for replying
How to do it in power query
I am doing all transformations in Dataflows so I need to add custom column in power query
Can you help me with taht please
Thanks a lot
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
105 | |
80 | |
68 | |
61 |
User | Count |
---|---|
143 | |
104 | |
103 | |
82 | |
70 |