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,

 

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

       

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        8 years ago

        Hi,

         

        Share the link from where i can download your file.  Please also show there the result you are expecting.