Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Guys,
Could you suggest which would be the best practice to choose between(previous year vs sameperiodlastyear) to calculate the sale for Last year? bit Confused.
Regards,
RSD
Solved! Go to Solution.
Hi @Anonymous,
Previousyear: This function returns all dates from the previous year given the latest date in the input parameter. For example, if the latest date in the dates argument refers to the year 2009, then this function returns all dates for the year of 2008, up to the specified year_end_date.
SAMEPERIODLASTYEAR: 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.
So as @LivioLanzo said, to use which one is up to your circumstance.
Regards,
Frank
Hi,
Yes. SAMEPERIODLASTYEAR() would be the best choice there. You may also want to review my post here - Show sales only for corresponding months in prior years.
Hope this helps.
Hi @Anonymous,
Previousyear: This function returns all dates from the previous year given the latest date in the input parameter. For example, if the latest date in the dates argument refers to the year 2009, then this function returns all dates for the year of 2008, up to the specified year_end_date.
SAMEPERIODLASTYEAR: 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.
So as @LivioLanzo said, to use which one is up to your circumstance.
Regards,
Frank
Thanks Frank!!
it depends on your goal, normally 'sameperiodlastyear' is used but in some circumstances you may want to use 'previousyear'
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Thanks Mate!!
So If I want to create a measure to calculate the year-to-date sales and to compare those sales to the
previous year for the same time period then SAMEPERIODLAST YEAR is the best choice right?
Hi,
Yes. SAMEPERIODLASTYEAR() would be the best choice there. You may also want to review my post here - Show sales only for corresponding months in prior years.
Hope this helps.
You are welcome.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |