Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
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 ?
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?
you need other features
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?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
90 | |
82 | |
76 | |
64 |
User | Count |
---|---|
143 | |
111 | |
108 | |
99 | |
95 |