Please see the workbook attached using 8.2. I am trying to create a view that displays only measures that trigger = 'warning' for the current month. For the measures that the results cause for a 'warning', I want to see all the past data points as well regardless if trigger ='warning' or trigger='no warning'
I assume this calls for a max(date) calc but I haven't been able to figure it out. Help, please!!
e.g. if trigger = 'warning' for MAX(date) then 'display'