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!