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 ...
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