Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
papeR
Regular Visitor

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
2022-07-05 15_18_57-Q-Reports_3_AP - Power BI Desktop.png
Measure "Kum. Fehlermenge":
2022-07-05 15_41_29-Q-Reports_3_AP - Power BI Desktop.png

Measure "Kum. Liefermenge":
2022-07-05 15_42_54-Q-Reports_3_AP - Power BI Desktop.png


!!! - Column 5 (Measure2) = Total error rate previous month (MoM)!!!
2022-07-05 15_25_24-Q-Reports_3_AP - Power BI Desktop.png


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

Resultlist

f2de3d0b-0184-4cba-9890-57aceefe1a0f.png

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 2
v-yanjiang-msft
Community Support
Community Support

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.

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):

2022-07-08 10_48_32-Q-Reports_3_AP - Power BI Desktop.png

 

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.