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)

))

[v-easonf-msft]

Hi, @netanel 

What does the measue   [Net USD average per Day]  look like in your table visual? Make sure the total value of the measure in the table is correct.

You can try the following formula:

Net USD average per Day for Budget 2021 =
CALCULATE (
    AVERAGEX ( Table, [Net USD average per Day] ),
    'Revenues DB'[Data Source] IN { "Budget 2021" }
)

or add filter ( 'Revenues DB'[Data Source] IN { "Budget 2021" } ) to measure [Net USD average per Day]  directly .

Best Regards,
Community Support Team _ Eason

[netanel · Accepted solution]

Thanks but I found the right formula

Diff$ Budget = Var _MTDA = CALCULATE([Net USD average per Day]) return _MTDA-[Net USD average per Day for Budget 2021]