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 ...
Need Help
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