• Skip to main content
  • Skip to footer

Curbal

Learn how to grow your business with your data and Power BI

  • Resources
    • DAX Glossary
    • Download Center
    • Template Apps
    • Data Stories Gallery
    • Solution Gallery
  • Courses
    • Introduction to Power BI – FREE Online course
    • Power Query Online Training for Power BI
    • M Language Online Course: The unofficial and Practical Reference Guide
  • Blog
  • Shop
    • Courses
    • Swag
    • Downloads
    • Donations
  • Cart
  • Register/ Log In
    • Become a Member
    • Log In
    • My account
    • My Courses
  • Contact
You are here: Home / CM Tooltip Glossary Pro+ / SAMEPERIODLASTYEAR

SAMEPERIODLASTYEAR

posted on April 20, 2018

« Back to Glossary Index

Syntax

SAMEPERIODLASTYEAR(<dates>)

Tutorial with example

 

In today’s video we will go through the DAX function called SAMEPERIODLASTYEAR. This little function is great for analyzing as the function itself says, the same period last year.

If you have seasonal business and you want to analyze what happended the same period the previous year, it will do it flowless.

Depending on how you use it, it could give you incorrect results. Stay tuned the entire video to understand how to avoid it.

Download example file:

Link to file

Remarks

The dates argument can be any of the following:

  • A reference to a date/time column,
  • A table expression that returns a single column of date/time values,
  • A Boolean expression that defines a single-column table of date/time values.

 

The dates returned are the same as the dates returned by this equivalent formula:

DATEADD(dates, -1, year)

This DAX function is not supported for use in DirectQuery mode.

Was this helpful?
[Total: 1    Average: 2/5]
« Back to Index

Reader Interactions

Comments

  1. Alan D

    November 21, 2018 at 9:44 pm

    Incorrect video was associated to the topic discussed

    Reply
    • Ruth Pozuelo Martinez

      November 22, 2018 at 12:29 pm

      I fixed that, thanks for letting me know!
      /Ruth

      Reply

Let us know your thoughts... Cancel reply

Footer CTA

Join our community of +12,500 professionals

Become a Member

Subscribe to YouTube

About us

Curbal AB
Kopparbergsvägen, 6
722 13 – Västerås
Sweden

OrgNo:5569680852 | VAT:SE556968085201

 

Location:

© Copyright 2014-2019 · Curbal AB · All Rights Reserved · Privacy Policy · Terms of Service · Refund Policy · Log In