Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Daily Rank Entries from Customers

I have a table where providers submit their capacity each day. Sometimes, if a new slot opens up they complete the form a second time to update their capacity. What I want to do is rank each entry fo...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Create a date from from Timestamp

     

    Date = [Timestamp].date
    or
    Date = date(year([Timestamp]),month([Timestamp]),day([Timestamp]))

     

    and then try this rank column

    Daily Rank =
    RANKX(
    FILTER(
    ProvCapacity,
    ProvCapacity[ProviderID]=EARLIER(ProvCapacity[ProviderID]) && ProvCapacity[Date]=EARLIER(ProvCapacity[Date])
    ),
    ProvCapacity[Timestamp]
    )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Create a date from from Timestamp

 

Date = [Timestamp].date
or
Date = date(year([Timestamp]),month([Timestamp]),day([Timestamp]))

 

and then try this rank column

Daily Rank =
RANKX(
FILTER(
ProvCapacity,
ProvCapacity[ProviderID]=EARLIER(ProvCapacity[ProviderID]) && ProvCapacity[Date]=EARLIER(ProvCapacity[Date])
),
ProvCapacity[Timestamp]
)

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you.  I have amended the DAX and it now works correctly.