topic Previous month - wrong values in DAX Commands and Tips

Previous month - wrong values

papeR — Tue, 05 Jul 2022 13:47:09 GMT

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!

Re: Previous month - wrong values

v-yanjiang-msft — Fri, 08 Jul 2022 07:30:34 GMT

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.

Re: Previous month - wrong values

papeR — Fri, 08 Jul 2022 08:53:46 GMT

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)]),

)

What else can be the problem?

Many thanks in advance,

papeR