materials
PowerBi Videos- All Materials added
CDF Formula: CALCULATE(COUNT([KPI]), FILTER(ALLSELECTED([BINS]), [(BINS)]<= MAX([(BINS)]))) / CALCULATE(COUNT([KPI]), ALL(BINS])) Moving Average Formula: AVERAGEX(DATESBETWEEN([Date] , MAX([Date]) - 4 , MAX([Date])), CALCULATE(AVERAGE([KPI]))) Example for 90perc: PERCENTILE.INC(metric, 0.9) Applying Conditional Formatting to Calculation Groups: Format String for % = #,##0.00%