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)
))
Did I answer your question?
Mark my post as a solution!
Appreciate your Kudos!
Connect on Linkedin
linkedin.com/in/netanel-shriki