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!
Solution SageHi 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!
Whitewater100,
Thanks for a quick response. So as I look at the file and mess around with it, it appears to do just what I need it to if I utilize the "between" style slicer. Is it possible to do the same thing with a "drop down" or "list" style slicer? I guess what I'm looking for is if it is possible to select a date rather than a range. If not, I can definitely make this one work for what I'm trying to accomplish. Thanks again for the help!
- Whitewater100
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?
- Whitewater100
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..