Forum Discussion

drrai66's avatar
drrai66
Icon for Resolver I rankResolver I
8 years ago
Solved

Last 12 months

Hi Experts

I have Incident data for 3 years and I want to utilize only last 12 months data Dynamically so when my data updated it always filters RECENT 12 months for me to work. Basically I control it in Tableau from Menu Like this.

 

Can someone will let me know how I can Set up this similar thing in Power Query or Otherwise?

Thanks in advance

Deepak

 

Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    HI drrai66

     

    Do you want your end users to be able to select their own filter ranges?

     

    If so, simply using your key date in a slicer on the report canvas offers plenty of flexibility

     

     

     

1 Reply

  • Phil_Seamark's avatar
    Phil_Seamark
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    HI drrai66

     

    Do you want your end users to be able to select their own filter ranges?

     

    If so, simply using your key date in a slicer on the report canvas offers plenty of flexibility