Forum Discussion

duggy's avatar
duggy
Icon for Advocate II rankAdvocate II
8 years ago

Display in table the maximum value and the date this value occured

Hi,

 

I am looking to show the maximum value of a column in a given slider date range. At the same time though I would like to show the date that this event occured.

The way that I have attempted to do this is to do the Top 1 transaction values. This elements shows nicely in the table, but when I add the date next to ir, it defaults to Earliest Date of the slider rather than the date that this maximum transaction numbers occured.

 

Much appreciated.

 

Need Help

4 Replies

  • v-cherch-msft's avatar
    v-cherch-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi duggy

     

    You may try to check the date and use ‘Don’t summarize’ for it. If it is not your case, please share your data sample. You can upload it to OneDrive or Dropbox and post the link here.

     

     

    Regards,

    Cherie

    • duggy's avatar
      duggy
      Icon for Advocate II rankAdvocate II
      8 years ago

      Nope, didnt work. Just shows the same date for all the rows irrespective of the change.

      I believe the reason is that I am adding the visual filter for Top 1 filter. When I remove the Top 1 filter the dates seem to show but it shows all the values, not the top 1 for each site.

       

      The combination seems to be throwing it off.

      • v-cherch-msft's avatar
        v-cherch-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        Hi duggy

         

        It seems you may try to use RANKX Function to create a measure for your data. Then drag the measure to visual level filter and then use TOP 1 for it.

         

        Regards,
        Cherie