time period

[Anonymous]

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

[djurecicK2 · Accepted solution]

Hi @Anonymous ,

 You can use SAMEPERIODLASTYEAR to accomplish this:

https://learn.microsoft.com/en-us/dax/sameperiodlastyear-function-dax

Please accept as solution if this answers the question- thanks!

[Anonymous]

hi djurecicK2,

Thanks a lot, super simple solution

double kudoz

regards,

dsmitha