Forum Discussion
Solved
Visualization breaks with DATEADD function and a slicer with non-consecutive dates
Hi! I have a visualization that compares this year's data to last year's + I have a slicer to represent different months. It works fine while filtering on consecutive months, but if I filter base...
DATEADD works with continues Dates..If the above trick don't work try using another formula..( many ways to show last years values )
DATEADD works with continues Dates..If the above trick don't work try using another formula..( many ways to show last years values )
Thanks!
I did know the "continous dates" restriction, but thought it mattered only in the context of a single function and didn't realize it applied to this case too. Still learning!
:)
Due to change in the filter context of the formula..Also still learning ( never stops )..:manhappy: