Forum Discussion
Solved
consistent display of multiple text fields
I would like to display some informational comments associated with my dataset. Imagine that you use a slicer to select a date datapoint. It is associated with the text string: "first day for qua...
Gotcha, well we can use CALCULATE() to solve this problem. I'm curious if it can be done easier, though. Anyway, this works:
Latest Date = CALCULATE(MAX(MuhDates[Comment]), FILTER(MuhDates, MuhDates[Date] = MAX(MuhDates[Date])))
Let's see if this forum allows GIF images:
Gotcha, well we can use CALCULATE() to solve this problem. I'm curious if it can be done easier, though. Anyway, this works:
Latest Date = CALCULATE(MAX(MuhDates[Comment]), FILTER(MuhDates, MuhDates[Date] = MAX(MuhDates[Date])))
Let's see if this forum allows GIF images:
Nice! thank you