Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

SamePeriodLastYear Doesn't Work

Submitted by Anonymous on ‎06-24-2019 09:18 PM

I have a test dataset with sales figures. I have also created a date table. I am trying to get the sales from the same period last year but the function sameperiodlastyear doesn't work as expected.

 

Instead of giving me blanks, it shifts dates to the next year and then gives me sales and the sales for same period last year.

 

Status: New
See more ideas labeled with:
2 Comments (2 New)
Comments
Anonymous
Not applicable
‎06-24-2019 09:21 PM

SPLY.JPG

prakashkavar
Regular Visitor
‎06-26-2019 01:16 AM

Hello Amol,

I am using sameperiodlastyear DAX formula in my report and it works fine. Can you give me more details.

E.g we used for our fiance dashboard to compare revenue and profit with last year business.

1)If i select current year (1st Jan-19 to 26th Jun-19 ) then sameperiodlastyear formulla gives data for last year (1st Jan-18 to 26th Jan-18) .

 

Please let me know if i understood anything wrong.

Idea Statuses