Date filtering Error

[Anonymous]

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 can see, I filtered the October 17, 2016 - October 17, 2017; it's given me just that [ NOT year over year ].

 If I filter just October 17, 2017; 2016 column goes away 😞

Could someone please help in this?

[Anonymous]

HI @Anonymous,

>> If I filter just October 17, 2017; 2016 column goes away 

Current slicer only support show the filtered part. If you removed the 2016 part in your slicer, matrix visual will shows the filtered 2017 part.

In my opinion, I'd like to suggest you write a measure to get the previous records based on calendar date.

Regards,

Xiaoxin Sheng

[Ashish_Mathur]

Hi,

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

[Anonymous]

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]

Hi,

Try to use the SAMEPERIODLASTYEAR() function.

[Anonymous]

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]

Hi,

Share the link from where i can download your file.

[Anonymous]

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]

Hi,

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