QoQ Calculation total problem

[andrejaar]

Hi Pbi Friends,

Having problem with 1 messure... it shows data correct, but total not so good.

Its a Purchase Order(only 2017 data) with Calendar (Only 2017 data) and Product Master

Basically i need to know :

( Average Price last quarter * Quantity Current Quarter ) - ( Average Price Current quarter * Quantity Current Quarter )

Its doing the calculations corretly, but when try to get total, its goes from "$4.00" to "$198.00"

Atual = Current Quarter Av. Price 

Ultimo = LastQuarter Av. Price

Qtde = Quantity

https://i.imgur.com/I8URAdT.png 

[v-chuncz-msft · Accepted solution]

@andrejaar,

You may try a similar way as shown here.

[andrejaar]

Hi Pbi Friends,

Having problem with 1 messure... it shows data correct, but total not so good.

Its a Purchase Order(only 2017 data) with Calendar (Only 2017 data) and Product Master

Basically i need to know :

( Average Price last quarter * Quantity Current Quarter ) - ( Average Price Current quarter * Quantity Current Quarter )

Its doing the calculations corretly, but when try to get total, its goes from "$4.00" to "$198.00"

Atual = Current Quarter Av. Price 

Ultimo = LastQuarter Av. Price

Qtde = Quantity

https://i.imgur.com/I8URAdT.png