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
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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        I attempted the "sameperiodlast year" function.. and got this error when using it in the matrix:

         

        :: Function 'SAMEPERIODLASTYEAR' expects a contiguous selection when the date column comes from a table on the 1-side of bi-derectional relationship