Z-Score Outlier Years = FlaggedPeriods ( DimYear[Year], [Is Z-Score Outlier] ) IQR Outlier Years = FlaggedPeriods ( DimYear[Year], [Is IQR Outlier] ) Modified Z-Score Outlier Years = FlaggedPeriods ( DimYear[Year], [Is Modified Z-Score Outlier] ) Grubbs Outlier Years = FlaggedPeriods ( DimYear[Year], [Is Grubbs Outlier] ) Gaussian Outlier Years = FlaggedPeriods ( DimYear[Year], [Is Gaussian Outlier] ) Z-Score Outlier Value = FlaggedValue ( [Is Z-Score Outlier], [Z-Score] ) IQR Outlier Value = FlaggedValue ( [Is IQR Outlier], [YoY Change] ) Modified Z-Score Outlier Value = FlaggedValue ( [Is Modified Z-Score Outlier], [Modified Z-Score] ) -- Written directly, not through FlaggedValue - see the FlaggedValue -- limitation covered earlier in the UDF section. Grubbs Outlier Value = IF ( [Is Grubbs Outlier] = TRUE (), [Grubbs Score], BLANK () ) Gaussian Outlier Value = IF ( [Is Gaussian Outlier] = TRUE (), [Gaussian Score], BLANK () )