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.
Hello guys,
I`ve a data set like below:
Request id | Price |
456 | $1568 |
456 | $1569 |
456 | $1570 |
456 | $1571 |
456 | $1572 |
456 | $1573 |
456 | $1574 |
456 | $1575 |
456 | $1576 |
456 | $1577 |
456 | $1578 |
457 | $1579 |
457 | $1580 |
457 | $1581 |
457 | $1582 |
457 | $1583 |
457 | $1584 |
457 | $1585 |
457 | $1586 |
345 | $1587 |
345 | $1588 |
345 | $1589 |
345 | $1590 |
345 | $1591 |
345 | $1592 |
345 | $1593 |
345 | $1594 |
Now i`d like to CREATE a new COLUMN to show me In the same request ID, what are the rank of each Price?
Thanks in advance.
Solved! Go to Solution.
Create Measure like below:
Please don't forget to hit THUMBS UP and Accept this as a solution if it helps you!
@Haidannx
Use the rankx function to create the column.
Rank Column = RANKX(FILTER('Table','Table'[Request id]=EARLIER('Table'[Request id])),'Table'[Price],,DESC,Dense)
Paul Zheng
@Haidannx
Use the rankx function to create the column.
Rank Column = RANKX(FILTER('Table','Table'[Request id]=EARLIER('Table'[Request id])),'Table'[Price],,DESC,Dense)
Paul Zheng
@Haidannx
If my solution solved your problem, please don't forget mark my reply.😝
Best,
Paul
Refer
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-wi...
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
I`ve read this article and try to follow their instructions step-by-step by the result comes out didn`t exact like i want it to be.
But still, thank you for your support.
Create Measure like below:
Please don't forget to hit THUMBS UP and Accept this as a solution if it helps you!
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 |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |