Budget calculation

[netanel]

Hello everyone,
I try to do a simple calculation of:
1. Daily average Less than average daily budget.

Diff$ Budget = 'Revenues DB'[Net USD average per Day] - [Net USD average per Day for Budget 2021]

And the numbers come out wrong.

2. When I do the same thing
Daily average less than last month's daily averages

Diff $ = 'Revenues DB'[Net USD average per Day]-[Net USD average per Day LM]

 The numbers come out excellent.

Attaches an example of the shape of the numbers in my database

(I have a side table of dates)

Perhaps these formulas will help understanding:

AVG Budget

Net USD average per Day for Budget 2021 =

CALCULATE(

    [Net USD average per Day],

    'Revenues DB'[Data Source] IN { "Budget 2021" }

)

LM AVG

Net USD average per Day LM =

AVERAGEX(

    KEEPFILTERS(VALUES('Date'[Date].[Day])),

    CALCULATE(SUM('Revenues DB'[Net USD]),DATEADD('Date'[Date],-1,MONTH)

))

[lbendlin]

Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services. Please show the expected outcome.