cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dsmitha
Super User
Super User

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

1 ACCEPTED SOLUTION
djurecicK2
Memorable Member
Memorable Member

Hi @dsmitha ,

 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!

 


If this post helps, then please consider accepting it as the solution to help other members find it more quickly.

View solution in original post

2 REPLIES 2
djurecicK2
Memorable Member
Memorable Member

Hi @dsmitha ,

 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!

 


If this post helps, then please consider accepting it as the solution to help other members find it more quickly.

hi djurecicK2,

 

Thanks a lot, super simple solution

double kudoz

 

regards,

dsmitha

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.