Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!