Forum Discussion

gauravnarchal's avatar
gauravnarchal
Post Prodigy
4 years ago

Rankx

First,  I need help to find out the personal best month of each agent ( Marketing fee and Sales).

 

Secondly, show it in the below format along with the current month total.

 

Third, if the current month's sales or marketing fee is higher than the there personal best month it should highlight.

 

Please click here to download the PBIX file. Click Here

 

Thanks

 

 

Need Help
Show and Tell

6 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    gauravnarchal , If you need top agent in each month

    create rank

    Rankx(filter(summarize(allselected(Table), Table[Month Year], Table[Agent]),  [month year] = max([month year]) , calculate(sum(Table[Marketing fee])),,desc,dense)

     

    you can filter rank =1

    • gauravnarchal's avatar
      gauravnarchal
      Post Prodigy
      4 years ago

      amitchandak - 

       

      Firstly,  I need to find out which was/is the personal best "month" of each agent ( Marketing fee and Sales).

       

      Secondly, show it in the table format along with the current month's total sales / Marketing fee.

       

      Third, if the current month's sales or marketing fee is higher than the there previous personal best month it should highlight.

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        4 years ago

        Hi,

        Based onthe dummy datase that you have shared, please show the expected result.