CAE: etude de cas - Rolling Average
Download as txt, pdf0 likes86 views
This formula calculates a 4-month rolling average of total lead time for contracts by averaging the total lead times of all contracts between the end of the month that is 4 months prior to the last date in the contracts table and the end of the most recent month. If the average total lead time is 0, it returns blank, otherwise it returns the calculated 4-month rolling average.
1 of 1
Download to read offline
![Rolling Average LT (4 Months) =
VAR daterow = LASTDATE(CONTRACTS[RFPO/HOTI])
RETURN
IF (
AVERAGE(CONTRACTS[Total Leadtime])=0,
BLANK(),
CALCULATE (
AVERAGE (CONTRACTS[Total Leadtime]),
ALLSELECTED(CONTRACTS),
DATESBETWEEN (
CONTRACTS[RFPO/HOTI],
EOMONTH(dateRow,-4)+1,
EOMONTH(dateRow,0)
)
)
)](https://image.slidesharecdn.com/pbimeetupro20171211rollingaveragelt4months-171227000039/85/CAE-etude-de-cas-Rolling-Average-1-320.jpg)
Ad
Recommended
More Related Content
More from MSDEVMTL (20)
Common features in webapi aspnetcoreMSDEVMTL
Groupe Excel et Power BI - Rencontre du 25 septembre 2018MSDEVMTL
Api gatewayMSDEVMTL
Common features in webapi aspnetcoreMSDEVMTL
Open id connect, azure ad, angular 5, web api coreMSDEVMTL
CAE: etude de casMSDEVMTL
Entity framework core 2 vs micro orm performancesMSDEVMTL
Groupe Excel + Power BI: Microsoft FlowMSDEVMTL
Gessie Exantus: etude de cas Custom MapMSDEVMTL
Les micro orm, alternatives à entity frameworkMSDEVMTL
Cathy Monier: Power Query et Power BIMSDEVMTL
Francis Paquet: Visualisations innovantesMSDEVMTL
Recently uploaded (20)
Ad
CAE: etude de cas - Rolling Average
- 1. Rolling Average LT (4 Months) = VAR daterow = LASTDATE(CONTRACTS[RFPO/HOTI]) RETURN IF ( AVERAGE(CONTRACTS[Total Leadtime])=0, BLANK(), CALCULATE ( AVERAGE (CONTRACTS[Total Leadtime]), ALLSELECTED(CONTRACTS), DATESBETWEEN ( CONTRACTS[RFPO/HOTI], EOMONTH(dateRow,-4)+1, EOMONTH(dateRow,0) ) ) )