Hi to all!!
this is my today issue: i have a slicer based on timestamp so I can review my data on a temporal view base. I have also in my report a card that expose the most recent date of the DB. My problem is that I want -when I operate with the slicer- the last date remain the same i.e. expose the last date of the timestamp column.
I have defined with DAX this measure:
LastDate = CALCULATE(MAX((last_six_month_history[operation_timestamp]));ALL(last_six_month_history))
but did't work as I desire. I used other combination of filters ad so on but when I use the slicer box my "last date" card change on the of selectionated date base.
This seem a very simple issue, but at the moment I didn't find the right solution!
Thanks in advance to whom help me in finding the solution!!
