Month offset showing a data in other months

[Sean_DG]

Hello, trying to adjust a measure made on an existing report to only show full months. There is a month offset built into the date calendar but using that results in data being posted for the rest of the calendar. I'm suspecting it's due to the MAX and MIN dates within the base measure but I'm a bit unfamiliar with this one.

Here is the table. As you can see there is extra data being shown for months after July

Here are the current dax formulas

Avg Amount Won =

VAR MaxDate = MAX(Dates[Date])

Var MinDate = MIN(Dates[Date])

Var Result =

CALCULATE(AVERAGE(Opportunity[Estimated_Total_Revenue__c]),DATESBETWEEN('Opportunity Field History'[EditDate],MinDate,MaxDate),

'Opportunity Field History'[Field]="StageName",

AND('Opportunity Field History'[OldValue]<>"Closed Won",

'Opportunity Field History'[OldValue]<>"Execute"),

OR('Opportunity Field History'[NewValue]="Closed Won",

'Opportunity Field History'[NewValue]="Execute"))

Return

Result

Avg Amount Won CY - 1M = calculate([Avg Amount Won],Dates[Fiscal Year]=2023&&Dates[Month Offset]<0)

Appreciate the help!

[johnt75]

I would look into why you have a row with blank for a Month name, it seems that you may have some data which does not have a date set. As the same value is showing for blank month as is showing for the months in the future, I think if you fix the underlying data that will fix your problem