Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I would like to get an expression built where I am able to see a minimum service date by a specific dimension (in this case a patient record number). I'm sure this is simple, but haven't found an example in the discussion forums.
I'm still getting all the years populated.
Can you show the image of what you are seeing?
I needed to suppress zero values, but otherwise the expression worked. If you have a minute, do you mind explaining how adding the Avg(1) at the end fixed the expression? Thank you so much for your support.
Avg(1) will equal to one for your selected years and will equal 0 for years out of selection.... So, basically the first part of the expressions shows the value for all years, but the second part (Avg(1)) forces it to show only the value for selected years....
Another way to do this would to do something like this (using if statement)
If(Year, Min({<Year>} TOTAL <[Patient Record Number]> Date))