Forum Discussion
Find Next Most Recent Date Dynamically
Hi Cody:
Here is link to file with date table added.
https://drive.google.com/file/d/1pVFYYs3-FHmOVLICwHWj3jvjYtKT1ohM/view?usp=sharing
Measure =var _lastDate=MAXX(FILTER(ALL('Table'),[Created_Date]=MAX('Table'[Created_Date])),[Created_Date])return CALCULATE(MAX('Table'[Created_Date]),FILTER('Table',[created_Date]=_lastDate))You will want to use "Measure. I hope this works for you!
Hi Cody:
Here is link to file with date table added.
https://drive.google.com/file/d/1pVFYYs3-FHmOVLICwHWj3jvjYtKT1ohM/view?usp=sharing
You will want to use "Measure. I hope this works for you!
Hello:
Yes you can a drop down or list slicer. Since it's on individual date you may be better off with between slicer, otherwise there is a lot to click. Can you please mark my answer as solution too? Thank you..
Hello,
I'm not sure if I'm missing something or what I may be doing wrong but as soon as I change the slicer from a "between" style to a "list" or "drop down" the calculated measure doesn't seem to display when I select a date. Any thoughts on what I might be missing/doing wrong?
Hi:
If you do the other styles of slicers and pick a date with no data, no measure can appear. For what I've seen so far, the BETWEEN slicer will work best. The formula is based on date, so using date field is really important and since we are asking for DAX to review all dates to pick the last one, between slicer makes sense. I hope this helps..
Hello,
I follow what you say, and that makes a lot of sense. Thanks again for all of the input/guidance.
Regards,Cody