Compare two time sales of two month with full amount of the last month. TITLE DOESNT SHOW PROBLEM

[Anonymous]

Hello,

I need your help again to solve an issue.

I want to compare the sales of the previous quarter with the sales of the acutal quarter. 

To make it more clear, I have to pictures:

Working Example

Not working Example

The first picture "Working Example" shows the right figures.

I choose the second quarter of 2018 and the sales are 1.250, column "Menge ausgew Quartal". In the first quarter of the 1.926 were sold, column "Menge_1Q_zuvor".

In the second picture "Not working Example" the third quarter of 2018 is choosen.

But the sale figures are wrong. Especially the figures of the column "Menge_1Q_zuvor", 844. The number should be 1250 and the column "Menge_2Q_zuvor" should be 1925, because it is the first quarter of 2018.

In my opion the problem is that sales for the third quarter are available until July 31. PowerBi just shows the sales firuges for the second quartel until June 30 or something like that. If I am wrong please correct me.

To calculate the columne "Menge_1Q_zuvor" I have choosen this formular:

Menge_1Q_zuvor = CALCULATE([Akt. Menge];DATEADD(Kalender[Datum];-1;QUARTER))

Akt. Menge is sum of sales.

I hope I explained my problem well enough so everybody understands it.

Does somebody has a solution or hint for my problem.

I am thankfull for every help I can get.

Christian

[v-cherch-msft]

Hi @Anonymous

You may try to use PARALLELPERIOD Function.

Regards,

Cherie

[Anonymous]

Hi Cherie,

thanks for your hint!!

Regards,

Christian