Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Previous date range based on slicer

Hi All,    I have a set of data with corresponding dates, and a slicer to filter the data based on the selected date range.   I am trying to create a second table that looks at the input of the s...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI Anonymous,

    I'd like to  suggest you take a look at below blog to know how to use DATE function to manually define filter range and do rolling calculations:

    Time Intelligence "The Hard Way" (TITHW)  

    Regards,

    Xiaoxin Sheng