Show Latest Survey Results Based on Date Filter

[Mickey___]

Hi,

I have two tables, one is a generic calendar and the other is survey results.

I am trying to create a flag so that only the most recent survey results show for a customer, though I want this to be dynamic and influenced by whatever filtering has been place on the calendar table. How do I go about achieving this?

Thanks!

[Mickey___ · Accepted solution]

Only solution that I was able to find was to create a measure to flag which is the latest survey based on the filtered date range (current date vs. max date) and then reference that measure when creating any subsequent measures. Was not able to find a solution which allowed for a toggle but this has worked well enough

[v-jiewu-msft]

Hi @Mickey___ ,

Please try the following methods and check if they can solve your problem:

1.Create the simple table.

2.Create the relationship between two tables.

3.Drag the date into the slicer.

4.Create the measure to filter.

Survey flag = 
VAR sur = SELECTEDVALUE(survey[survey])
RETURN
IF(sur = "customer", 1, 0)

5.Drag the measure to the Filters pane and set the show items is 1.

6.The result is shown below.

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?