Anomaly Detection in Excel and in Power BI

This video illustrates how to find anomalies in data in both Excel and in Power BI.

In Excel, we use 3rd Order Derivatives to find the anomalies and in Power BI we use the built in anomaly detection utility. I demonstrate exactly how to achieve your aims of finding anomalies and show you that I find ten anomalies in Excel but just three in Power BI

Overall, what you see is not so difficult and you can download my Excel and Power BI files so that you can check how to do what I did and then do it yourself.

Excel file: https://docs.google.com/spreadsheets/...
Power BI file: https://drive.google.com/file/d/1ds6a...