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
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