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

[duggy]

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.

[Ashish_Mathur]

Hi,

Share some data and show the expected result.

[v-cherch-msft]

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]

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]

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