Forum Discussion

saud968's avatar
saud968
Memorable Member
2 years ago
Solved

Ranking for multiple entries

Hi,  I have multiple entries as you can see below screenshot the number should have MonthUnique Count as 1, 2 but it is showing up as 1     https://drive.google.com/file/d/1Y_qQCdj5pxf2Pv...
Data Protection
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • saud968's avatar
    saud968
    2 years ago

    Ahmedx I was able to get the work done by 

    MonthUniqueCount =

    RANKX(
        FILTER(
            WeekUniqueTicketTable,
              WeekUniqueTicketTable[Month Unique Ticket] = EARLIER(WeekUniqueTicketTable[Month Unique Ticket])
           
        ),
        WeekUniqueTicketTable[EDITED_DATE],
        ,
        ASC
saud968's avatar
saud968
Memorable Member
2 years ago

Just wanted to add this as a screenshot because for some weird reason, the reply is not saving. 

 

saud968's avatar
saud968
Memorable Member
2 years ago

Ahmedx I was able to get the work done by 

MonthUniqueCount =

RANKX(
    FILTER(
        WeekUniqueTicketTable,
          WeekUniqueTicketTable[Month Unique Ticket] = EARLIER(WeekUniqueTicketTable[Month Unique Ticket])
       
    ),
    WeekUniqueTicketTable[EDITED_DATE],
    ,
    ASC
  • saud968's avatar
    saud968
    Memorable Member
    2 years ago

    Ahmedx can I accept my own solution as a solution? Is it possible and not violate any rules. If not could you please accept it as solution for me.