Forum Discussion

Curious2115's avatar
Curious2115
Frequent Visitor
3 years ago
Solved

Day to Day Sales Forecast Difference

Hello,   I have this data where I forecast sales in the future. This forecast changes every day, and I am trying to create a measure where it shows the difference in the day-to-day sales forecast (...
  • BeaBF's avatar
    BeaBF
    3 years ago

    Curious2115 Hi!
    you can create a measure like:
    Sales Forecast Difference =
    VAR CurrentDate = MAX('YourTable'[Sales Date])
    VAR PreviousDate = CALCULATE(MAX('YourTable'[Sales Date]), 'YourTable'[Sales Date] < CurrentDate)
    VAR CurrentForecast = CALCULATE(SUM('YourTable'[Sales Forecast]), 'YourTable'[Sales Date] = CurrentDate)
    VAR PreviousForecast = CALCULATE(SUM('YourTable'[Sales Forecast]), 'YourTable'[Sales Date] = PreviousDate)
    RETURN
    CurrentForecast - PreviousForecast

    BBF

BeaBF's avatar
BeaBF
Icon for Super User rankSuper User
3 years ago

Curious2115 Hi!
you can create a measure like:
Sales Forecast Difference =
VAR CurrentDate = MAX('YourTable'[Sales Date])
VAR PreviousDate = CALCULATE(MAX('YourTable'[Sales Date]), 'YourTable'[Sales Date] < CurrentDate)
VAR CurrentForecast = CALCULATE(SUM('YourTable'[Sales Forecast]), 'YourTable'[Sales Date] = CurrentDate)
VAR PreviousForecast = CALCULATE(SUM('YourTable'[Sales Forecast]), 'YourTable'[Sales Date] = PreviousDate)
RETURN
CurrentForecast - PreviousForecast

BBF

  • Curious2115's avatar
    Curious2115
    Frequent Visitor
    3 years ago

    Hello, I updated 'YourTable'[Sales Date] to 'YourTable'[Forecast Updated Date], and it worked. thank you so much!