Tag: Solving Analytical Scenarios

How To Create A Forward Forecast In Power BI: Advanced Forecasting Techniques

By Sam McKay, CFA on June 14, 2020September 9, 2020

Forecasting analysis in Power BI can be completed in quite an effective manner if you utilize the time intelligence functions in DAX effectively. In this example, I go through the many options you have available to automatically create a forecast in Power BI based on historical information. Your forecasts in a lot of cases will

Posted in: DAX, Forecast in Power BI, Forecasting, Forward Forecast, Power BI Forecasting Techniques, SAMEPERIODLASTYEAR, Solving Analytical Scenarios, Time Intelligence

DAX Power BI Time Intelligence

Compare Cumulative Information Over Different Months In Power BI

By Sam McKay, CFA on October 10, 2019September 11, 2020

Showcasing cumulative results in Power BI is such a powerful way to visualize your data over time, especially if you are trying to show the difference in performance from one time period to another. When you try to present this at a daily or even monthly level, identifying the trend isn’t always so obvious. When

Posted in: Cumulative Totals, Data visualisation, DAX, Power BI, Solving Analytical Scenarios, Time Comparison, Time Intelligence