Previous month - wrong values

[papeR]

Hey folks, I'm slowly walking on my gums as I just don't get the actually pretty obvious target result.

I'm really happy about every support!
Main Target: Derive a trend over time using quotes

My project (list view) :
- Column 1 (Datetable) = Year
- Column 2 (Datetable) = Quarter
- Column 3 (Datetable) = Month

- Column 4 (Measure) = Total error rate

Measure "Kum. Fehlermenge":


Measure "Kum. Liefermenge":



!!! - Column 5 (Measure2) = Total error rate previous month (MoM)!!!


- Column 6 (Measure 3) = Difference between the month

Resultlist


Only the second list entry/row returns the expected value.
The quotas afterwards do not correspond to the target values.

What can be the problem here? Please forgive me for being such a PowerBI greenhorn! 🙂
Thanks in advance for any support!

[v-yanjiang-msft]

Hi @papeR ,

According to your description, please try to modify the formula like this:

Gesamtfehlerquote Vormonat =
CALCULATE (
    [Gesamtfehlerquote],
    FILTER (
        ALL ( 'Datum(xlsx)' ),
        EOMONTH ( 'Datum'[Date], 0 ) = EOMONTH ( MAX ( 'Datum'[Date] ), -1 )
    )
)

Best Regards,
Community Support Team _ kalyj

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

[papeR]

Hey @v-yanjiang-msft,

thanks a lot for the suggestion! 

Unfortunately, i still get the wrong value. I figured out, that the returned values are the Quotes vor each month, but not accumulated (target):

The formula for the column "EK- FehlermengQ (var)" is:

EK- FehlermengenQ (var) =

divide(

calculate(

sum('Q-Reporte (xlsx)'[Fehler-menge]),

'Q-Reporte (xlsx)'[entdeckt von]="Wareneingang"),

sum('WE-Zeilen (ELPOSP)'[WE-gelieferte Menge (LPLFS1)]),

0

)

What else can be the problem?

Many thanks in advance,

papeR