Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Date filtering Error

Hi,    I am wanting to use this date filter in my reports:      I am also wanting to do a Year over Year comparison with the data after the date is selected:          As you ca...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Your question is not clear.  What do you want to show in the Table visual?

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Hi,

I want to show current and last year's count for the same month and day that's filtered by the date slicer.
  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi,

     

    Try to use the SAMEPERIODLASTYEAR() function.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago
      How would I factor it into my sum measures?

      The table is counting total Sales. I am unsure how to use it within this visual.
      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        8 years ago

        Hi,

         

        Share the link from where i can download your file.