Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
PBIX link:
https://drive.google.com/file/d/1UKVVjEndFDuBUnsOAGVbg_CnweY2cR-d/view?usp=sharing
In the file attached, I want to get the average of next 3 months Forecasted payments(excluding current month)
I understand a formula like this will work:
Next 3 month average = CALCULATE (
AVERAGE(‘To Collect’[To Collect] ),
DATESINPERIOD ( ‘Date’[Date], EOMONTH(TODAY(),0), 3, MONTH ))
But , in the current example Forecasted Payments formula is bit complicated, so I don’t know how to make it work in this case.
Please try this measure expression to get the 3 month average.
FP 3 Month =
VAR maxdate =
MAX ( 'Date'[Date] )
VAR startnextmonth = maxdate + 1
VAR end3month =
EOMONTH (
startnextmonth,
2
)
RETURN
CALCULATE (
AVERAGEX (
DISTINCT ( 'Date'[MonthInCalendar] ),
DIVIDE (
[Incremental POC],
1 - [LastMonthPOC]
) * 474
),
FILTER (
ALL ( 'Date'[Date] ),
'Date'[Date] >= startnextmonth
&& 'Date'[Date] <= end3month
)
)
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
19 | |
14 | |
10 | |
7 |