Forum Discussion
Find Next Most Recent Date Dynamically
Hi, I'm struggling to find a solution in the forum for what I'm trying to accomplish, with that being said thank you and I appreciate any/all help to the resolution to (or guidance to a similar situ...
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!
Whitewater100
Solution Sage
Solution SageHi:
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