Solving Analytical Scenarios Archives

Tag: Solving Analytical Scenarios

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

By Sam McKay, CFA on June 14, 2020May 11, 2022

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. You may watch the full video of this

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

DAX Power BI

Compare Cumulative Information Over Different Months In Power BI

By Sam McKay, CFA on October 10, 2019May 4, 2022

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. You may watch the full video of this tutorial at the bottom of this blog. When you try to present this

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