Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
How can I create a column "Result" below by keepin a count of repeating values from Col1? Thanks.
Col 1 Result
a 1
b 1
a 2
c 1
b 2
a 3
c 2
Thanks Eric!
@n2p2gupta wrote:
Thanks Eric!
If you have no further question, could you accept the reply as solution to close this thread? For any question, feel free to post.
@n2p2gupta wrote:
How can I create a column "Result" below by keepin a count of repeating values from Col1? Thanks.
Col 1 Result
a 1
b 1
a 2
c 1
b 2
a 3
c 2
You need an index column to indicate the rows order.
Then create a calculated column as
Result = RANKX ( FILTER ( 'Table', 'Table'[Column1] = EARLIER ( 'Table'[Column1] ) ), 'Table'[Index], , ASC, DENSE )
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 |
---|---|
15 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
29 | |
3 | |
3 | |
2 | |
2 |