Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
koorosh
Post Partisan
Post Partisan

Same Period Last Year

Hi, Why sameperiodlastyear did not result in one year back from the date column selected?

 

 

9 REPLIES 9
VilmarSch
Post Partisan
Post Partisan

Apparently it's normal:

 

The SAMEPERIODLASTYEAR is equivalent to DATEADD(dates, -1, year).
Its biggest year in the date table is 2019, so SAMEPERIODLASTYEAR will show the previous year, i.e. 2018.
Its smallest year in the date table is 2014, so SAMEPERIODLASTYEAR will not show the previous year, i.e. 2013.

 

Sem título.png

Why it is normal that does not show 2013? If you use DATEADD(dates, 1, year), and the biggest one is 2016 (attached file) the result shows 2017.

koorosh
Post Partisan
Post Partisan

 
Ahmedx
Super User
Super User

SELECTCOLUMNS('Table',"Date",SAMEPERIODLASTYEAR('Table'[Date]))
will give empty at the beginning , go down and you see dates

Thanks. Why there are no empty rows or 2013 rows in the sameperiodlastyear table?
And why there is no 2013 rows in selectcolumn table and it shows empty rows ? 

Ahmedx
Super User
Super User

it works, it moves the date back one year.
you will lose the last year, and you will not see the first year, since it is not in the table.
if your date is early 2014 and late 2023
you will see only 2014 and 2022, and do not see 2013 because it is not in the table

Do you mean 2013 will not be in the output? why?

Ahmedx
Super User
Super User

you need other features

Screen Capture #1284.png

Thanks.But my question is , in the defination of this function was written "Returns a table that contains a column of dates shifted one year back in time from the dates in the specified dates column, in the current context."
Why I can not get this result?

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.