Forum Discussion
netanel
Post Prodigy
Post ProdigyBudget calculation
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
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)
))
1 Reply
- lbendlin
Super User
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.
