Forum Discussion

Mema's avatar
Mema
Frequent Visitor
6 years ago

Greatest difference

I have a table that has 3 columns that make up a unique identifier, I have combined these in a new column. I have been able to do the difference for each one of these for each period in the financial year but I want to show which of these combinations had the greatest change each financial period and which period had the most movement.

 

Thanks for any help

Need Help
Tutorial Requests

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Mema 

     

    I'm not sure what the question is here.

     

    Can you advised what you have tried and what you are having a problem with?

    • Mema's avatar
      Mema
      Frequent Visitor
      6 years ago

      I am asking how I can show the top 5 ranked differences, I have tried using Rankx in a calculated column, then using top n as a filter. I have tried to create a rankx measure, I can't get that to work at all, I have tried a filter on the measure that is rank less than or equal to 5

      • dax's avatar
        dax
        Community Support
        6 years ago

        Hi Mema,

        You said you can't make the rankx work in report, which problem did you get? And what is rankx difference? In addition, if possible, could you please inform me more detailed information (such as your sample data and your expected output)? Then I will help you more correctly.

        Please do mask sensitive data before uploading.

        Thanks for your understanding and support.
        Best Regards,
        Zoe Zhi

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.