Forum Discussion

Divous's avatar
Divous
Icon for Helper III rankHelper III
4 years ago

RANKX with multiple FILTER

Hi community,   I would like to add the order of support and users (see desired output). I manage to number the order according to the id and time columns with RANKX, but I no longer know how to ad...
Need Help
Tutorial Requests
AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
4 years ago

Divous  Thanks for your reply and sorry for my delay. I asked about your rationale because my formula gives slightly different answers to what you had in your desired output and I just wanted to check if you had all the right info or just human error? Is my formula still working for you? Please mark as solution if so. 

For your additional question, open a new thread and post more info on what that message_text column looks like and your desired output column again - that is really helpful for us to understand exactly what you need. 

Divous's avatar
Divous
Icon for Helper III rankHelper III
4 years ago

Hi AllisonKennedy ,

thanks for reaching out! Info from you is really good and working good, but answers are slighly different so I am still trying to achieve my goals.

 

I open new thread as you suggested and hoping that I described everything and in better way. Thread is here
Chat statistics - Microsoft Power BI Community