Forum Discussion

robertosangi's avatar
robertosangi
Helper I
4 years ago
Solved

Ranking values comparing two weeks

Hi,    I have one question regarding the possibility to rank values based on a comparison between weeks.   Here the problem: I have this kind of table: First of all i want to have first ...
Need Help
  • robertosangi's avatar
    robertosangi
    4 years ago

    Seems is not working anyway johnt75 

     

    Those are now the formulas but the results seems wrong because i filtered the current week table manually and results 433 count and not 2264 as per measure 


    Could you please rewrite formulas as you expected? Thanks

     

johnt75's avatar
johnt75
Super User
4 years ago

which measure is in the Wn column on that visual? that's the one you should use for as the base measure for calculating PdL for current week.

also, I think the RANKX functions need the data table as a parameter, not the Date table

robertosangi's avatar
robertosangi
Helper I
4 years ago

This are the values johnt75 :

 

Wn = PdLCurrentWeek

Wn-1 = PdlLastWeek

 

  • johnt75's avatar
    johnt75
    Super User
    4 years ago

    You need the RANKX functions to work over the UT table, not the Date table

    • robertosangi's avatar
      robertosangi
      Helper I
      4 years ago

      Seems is not working anyway johnt75 

       

      Those are now the formulas but the results seems wrong because i filtered the current week table manually and results 433 count and not 2264 as per measure 


      Could you please rewrite formulas as you expected? Thanks

       

      • johnt75's avatar
        johnt75
        Super User
        4 years ago

        Is it possible to share your pbix file ?