How ParellelPeriod is different than SamePeriodLastYear?

Hi RupeshR ,

The main differences between them are as follows:

(1)SamePeriodLastYear is working based on the DYNAMIC period in the filter context.

ParallelPeriod is working STATICALLY based on the interval selected in the parameter.

(2)ParallelPeriod can go more than one interval back and forward, while SamePeriodLastYear only goes one year back.

(3)ParallelPeriod only works on month, quarter, and year.

For example:

For Q4 of 2006 SamePeriodLastYea will return Q4 of 2005, but ParallelPeriod (year) will return all 2005.

Please refer to the following document for more information.

https://laptrinhx.com/news/power-bi-dax-sameperiodlastyear-paralellperiod-and-dateadd-AowbRAW/

Power BI DAX: SAME PERIOD LAST YEAR, PARALELL PERIOD (databear.com)

DateAdd vs ParallelPeriod vs SamePeriodLastYear; DAX Time Intelligence Question - RADACAD

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.