PARALLELPERIOD not working as I want it to

[alexpegg86]

hi all,

I'm trying to use PARALLELPERIOD to return sales data for the same period last year. For some reason, it shows the annual total, but i want to see it by month. See below the screenshot of the measure:

Any ideas on why this may be?

Thanks.

[BeaBF]

@alexpegg86 Hi! Can you paste sample data and the measure? or share the pbix file

BBF

[alexpegg86]

Hi @BeaBF ,

I've saved them to google drive - hopefully the links work for you:

Power BI file: https://drive.google.com/file/d/1OJ82btg26MRy_cvH3BWhuOQ5eN0ZA705/view?usp=drive_link

csv data source: https://drive.google.com/file/d/1CiuDqnm0so5Tsc2nNPzSt28RozerhU3u/view?usp=drive_link

[BeaBF]

@alexpegg86 I'va found the solution.

You need a Calendar Table, i've created one in this way:

DateTable = DISTINCT('Total Soft Drinks Output'[Period End Date])

Then, you have to create a relationship between this new table and the Total Soft Drinks Output (one to many), in this way:

At least, adapt your measure as:

Value Previous Month =

CALCULATE(

    SUM('Total Soft Drinks Output'[Spend]),

    PARALLELPERIOD('DateTable'[Period End Date], -1, MONTH)

)

or also:

Value Previous Month =

CALCULATE(

    SUM('Total Soft Drinks Output'[Spend]),

PREVIOUSMONTH(DateTable[Period End Date])

)

you need to use date of the new DateTable in the Visual, so you need to calculate Period, Year, on the new DateTable. It will work fine:

if you send me your mail on pvt message i can send you the pbix arranged.

if it's ok, please accept as solution.

BBF

[alexpegg86]

Thanks @BeaBF .

I actually want the value to be the value for the same period last year... so June 2024 would show June 2023... would i just change the measure to:

CALCULATE(

    SUM('Total Soft Drinks Output'[Spend]),

    PARALLELPERIOD('DateTable'[Period End Date], -12, MONTH)

)

?

[BeaBF · Accepted solution]

@alexpegg86 

You can use both:

Value Previous Year=

CALCULATE(

    SUM('Total Soft Drinks Output'[Spend]),

PREVIOUSYEAR(DateTable[Period End Date])

)

or

Value Previous Year=

CALCULATE(

    SUM('Total Soft Drinks Output'[Spend]),

PARALLELPERIOD(DateTable[Period End Date], -1, YEAR)

)

Please, accept my answer as a solution.

BBF