Power BI Masterclass - Learning DAX: Sales Forecast on Prior 3 Months Average

The video tutorial covers the use of time intelligence to predict sales using the last three months of data. It demonstrates creating a date table, formatting it, and displaying total sales. The tutorial then guides on creating a sales forecast measure using DAX, focusing on variables and the return keyword. Finally, it explains how to visualize the forecast and filter data for meaningful insights.

What is the primary goal of the sales forecasting discussed in the video?

• To calculate total cost for the upcoming quarter

• To predict sales for the next year

• To predict sales for the kernels based on the last three months

• To analyze total profit over the last year

What is the first step in preparing the data for sales forecasting?

• Creating a profit table

• Removing the year from the hierarchy

• Creating a date table and adjusting its format

• Adding a new column for total cost

Which function is primarily used to modify the filter context in the sales forecast measure?

• CALCULATE

• FILTER

• SUM

• AVERAGE

What is the purpose of using the DATEADD function in the sales forecast measure?

• To add new dates to the table

• To remove dates from the table

• To shift the date range by a specific interval

• To calculate the average of sales

Why is the DIVIDE function used in the sales forecast measure?

• To multiply the sales values

• To add a constant value to sales

• To avoid division by zero errors

• To subtract sales from profits

What should be done if the sales forecast for certain months does not make sense?

• Ignore the forecast for those months

• Filter out the nonsensical forecasts

• Recalculate using a different formula

• Increase the number of months considered

What is a potential limitation of the sales forecast method demonstrated in the video?

• It does not use any variables

• It cannot be visualized in a chart

• It only considers the last three months of data

• It requires data from the entire year