Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I created a rank with this code
RANK = RANKX(FILTER(
'Table',
'Table'[ID]= EARLIER('Table'[ID]) &&
'Table'[Date Time] < EARLIER('Table'[Date Time])
),'Table'[Date Time],,ASC,Skip)
which to some extent worked and followed the proper order but it gave me 1,1,1,4 instead of 1,2,3,4. The Date and Time is the same for the first three rows. Next thing I did was add a column with random values.
SupportingColumn = RANDBETWEEN(1,COUNTROWS('Table'))
I was hoping that I could still do the same grouping but sort it by some index cause it doesn't matter which row is before the other. However it completely disorigented my position.
RANK = RANKX(FILTER(
'Table',
'Table'[ID]= EARLIER('Table'[ID]) &&
'Table'[Date Time] < EARLIER('Table'[Date Time])
),'Table'[SupportingColumn],,ASC,Skip)
same code as before but now completely placing the values all over the place. Not sure how to do this.
@user35131 change
Skip to DENSE
So change from skip to dense doesn't solve it. What it does it changes 1,1,1,4 to 111,2. I'm more satisfied with the 1,1,1,4 because at least the 4 is in the proper position.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
68 | |
53 | |
39 | |
33 |
User | Count |
---|---|
71 | |
63 | |
57 | |
49 | |
46 |