topic Re: PARALLELPERIOD not working as I want it to in DAX Commands and Tips

PARALLELPERIOD not working as I want it to

alexpegg86 — Tue, 09 Jul 2024 10:24:45 GMT

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.

Re: PARALLELPERIOD not working as I want it to

BeaBF — Tue, 09 Jul 2024 10:45:09 GMT

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

BBF

Re: PARALLELPERIOD not working as I want it to

alexpegg86 — Tue, 09 Jul 2024 13:06:48 GMT

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

Re: PARALLELPERIOD not working as I want it to

BeaBF — Tue, 09 Jul 2024 13:42:26 GMT

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

Re: PARALLELPERIOD not working as I want it to

alexpegg86 — Tue, 09 Jul 2024 13:58:30 GMT

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)

)

Re: PARALLELPERIOD not working as I want it to

BeaBF — Tue, 09 Jul 2024 14:24:44 GMT

alexpegg86

You can use both:

Value Previous Year=

CALCULATE(

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

PREVIOUSYEAR(DateTable[Period End Date])

)

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