none
Forecast for the remaining months based on the last month's actual for a given financial year RRS feed

  • Question

  • Hi: I am trying to do forecast in PQ. Based on the last date in the data below I would like to do forecast for the remaining months for a given financial year. In the scenario below, the last month data is for Feb-20 and the forecast would need to be calculated between March-20 and Jun-20 (highlighted in blue). Only the line item that indicates "M" (monthly) in the Composite column needs to be considered and "A" to be ignored. At the end of March the forecast needs to be between April-20 and June-2020.  Any assistance would be greatly appreciated. Thanks

    Input

    Output

    Wednesday, March 4, 2020 11:04 PM

Answers

  • Hi there. PQ doesn't contain any built-in forecasting capabilities. How are you wanting to calculate the forecast?

    Another option would be to load it into Excel or PBIDesktop and then apply the forecasting there.

    Ehren

    • Marked as answer by M.Awal Tuesday, March 17, 2020 1:54 AM
    Monday, March 16, 2020 8:24 PM
    Owner

All replies

  • Hi there. PQ doesn't contain any built-in forecasting capabilities. How are you wanting to calculate the forecast?

    Another option would be to load it into Excel or PBIDesktop and then apply the forecasting there.

    Ehren

    • Marked as answer by M.Awal Tuesday, March 17, 2020 1:54 AM
    Monday, March 16, 2020 8:24 PM
    Owner
  • Thanks for your reply.
    Tuesday, March 17, 2020 1:54 AM