time period

Hi,

 

Request your guidance to solve this issue

 

We have a dashboard which shows sales for the day and month when we select a salesman from the slicer. We would like to have the sales during the last year on the same date for the selected salesman. i.e if sales of 02/12/2022 is  $100  then it should also show sales for the date 02/12/2021.  how can we make this happen

 

kindly advise

 

regards,

dsmitha