cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shaykoooo Regular Visitor
Regular Visitor

PARALLELPERIOD vs DATEADD

Hi,
I would like to understand the difference between the two. Today is March 8th, 2018, so DATEADD ( 'Date'[Date], -1, YEAR ) ) would return the sales of last year but only from 1/1/2017 through March 8th, 2017? Whreas PARALLELPERIOD( 'Date'[Date], -1, YEAR ) ) would return sales from 1/1/2017 through March 30th, 2017? Am I correct in both statements?
If you can refer to sales on your answer, that would be great. ie for each function, sales for what periods will I receive?

TY
2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: PARALLELPERIOD vs DATEADD

The PARALLELPERIOD function is similar to the DATEADD function except that PARALLELPERIOD always returns full periods at the given granularity level instead of the partial periods that DATEADD returns. For example, if you have a selection of dates that starts at June 10 and finishes at June 21 of the same year, and you want to shift that selection forward by one month then the PARALLELPERIOD function will return all dates from the next month (July 1 to July 31); however, if DATEADD is used instead, then the result will include only dates from July 10 to July 21.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

Super User
Super User

Re: PARALLELPERIOD vs DATEADD

What should happen is that the PARALLELPERIOD function would return all dates from the next month (July 1 to July 31) but DATEADD should only July 1 to July 21.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

11 REPLIES 11
Super User
Super User

Re: PARALLELPERIOD vs DATEADD

The PARALLELPERIOD function is similar to the DATEADD function except that PARALLELPERIOD always returns full periods at the given granularity level instead of the partial periods that DATEADD returns. For example, if you have a selection of dates that starts at June 10 and finishes at June 21 of the same year, and you want to shift that selection forward by one month then the PARALLELPERIOD function will return all dates from the next month (July 1 to July 31); however, if DATEADD is used instead, then the result will include only dates from July 10 to July 21.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

shaykoooo Regular Visitor
Regular Visitor

Re: PARALLELPERIOD vs DATEADD

And what if the period was from June 1 through June 21?
Super User
Super User

Re: PARALLELPERIOD vs DATEADD

What should happen is that the PARALLELPERIOD function would return all dates from the next month (July 1 to July 31) but DATEADD should only July 1 to July 21.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

Anonymous
Not applicable

Re: PARALLELPERIOD vs DATEADD

Hello
Sorry raise the topic again, but I have a problem here, perhaps because of the month of February has fewer days than other months.
Being today 26 / March I want to compare sales from March 1 to March 26 with sales from February 1 to February 26
Apparently simple, but in applying the measurements I do not see the correct result.
The table shows me the sales from January 30 to February 22 using DATEADD

While using PARALLELPERIOD shows me the sales from 01 / Feb to 22 / Feb

The problem is that I have sales on the 25th and 26th of February that are not considered by the measures

 

 

 

 

Super User
Super User

Re: PARALLELPERIOD vs DATEADD

Hi,

Share some data and show the expected result.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

Re: PARALLELPERIOD vs DATEADD

Super User
Super User

Re: PARALLELPERIOD vs DATEADD

Hi,

I cannot understand anything from those images.  Someone else will help you.  Sorry.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

Re: PARALLELPERIOD vs DATEADD

I'll try to explain it better.
What I need is to have the sales number from Feb. 1 to Feb. 26 to show on the multiply card in conjunction with the indicator that shows sales for the current month (March 1 to March 26).
One indicator is sales of the month and the other sales in the same period of the previous month (MPMA Sales)
In the table I put the dates of sales and the three measures that I used to try to reach these numbers.
The measures that use PARALLELPERIOD AND DATEADD, -1, MONTH show the sales of the whole February month, but I only want the sales until the same day of today only that in the previous month, in the case would be until February 26.
The other measure used DATEADD, -30, DAY totals sales considering 30 days before the 26th of February and then considers and adds sales from the end of January, which does not interest me in the context I want to compare
Finally, the three measures mentioned above are inserted in the multiple card, showing the same results of the totals in the table, but none of them are showing the result that I need, which are sales for the same period of the previous month.
Updating to today's date (March 28th) I would have sales from March 1 to March 27 in a gauge and sales from Feb. 1 to Feb. 27 on one of the indicators that are detailed in the table.

Super User
Super User

Re: PARALLELPERIOD vs DATEADD

Hi,

What should the result be when the date is March 31?  What dates should the formula consider for the previous month?


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 243 members 2,661 guests
Please welcome our newest community members: