• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

DATEADD vs. PARALLELPERIOD

S

Shay A

Member
Hi,
I would like to understand the difference between the two.
Today is March 4th, 2018, so
DATEADD ( 'Date'[Date], -1, YEAR ) ) would return the sales of last year but only from 1/1/2017 through March 4th, 2017? Whreas
PARALLELPERIOD( 'Date'[Date], -1, YEAR ) ) would return sales from 1/1/2017 through March 30th, 2017?
Am I correct in both statements?

TY!
 
You must log in or register to reply here.
Back
Top