Forum Discussion

papeR's avatar
papeR
Regular Visitor
4 years ago

Previous month - wrong values

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!

2 Replies

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    4 years ago

    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's avatar
      papeR
      Regular Visitor
      4 years ago

      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