Power BI Advanced Visuals: Creating Moving Average and Percentile Charts

Power BI Advanced Visuals: Creating Moving Average and Percentile Charts

Moving Average Formula:
AVERAGEX(DATESBETWEEN([Date] , MAX([Date]) - 4 , MAX([Date])), CALCULATE(AVERAGE([KPI])))

Example for 90perc:
PERCENTILE.INC(metric, 0.9)