Forum Discussion

Cali_2020's avatar
Cali_2020
Helper I
6 years ago
Solved

Current forecast vs previous forecast

Hello all,   My apologies in advance if this has already been answered in a previous post but I haven't found a solution to what I am trying to do.   On a monthly basis, my team performs a foreca...
Need Help
  • Cali_2020's avatar
    Cali_2020
    6 years ago

    Hi az38 ,

     

    This works great! Thank you! Just one more question, can I apply this measure to calculate the previous month's forecast? I tried the following but it returns the same results:

     

    =CALCULATE([Forecast - Revenues],DATEADD(Data[Forecast Date],-1,MONTH))

     

    Thanks again!

  • az38's avatar
    az38
    6 years ago

    Cali_2020 

    try

    var _maxPrevDate = CALCULATE(MAX(Data[Forecast Date]),Data[Forecast Date]<=EOMONTH(TODAY(),-1))

     

    do not hesitate to give a kudo to useful posts and mark solutions as solution

Cali_2020's avatar
Cali_2020
Helper I
6 years ago

Hi az38 ,

 

This works great! Thank you! Just one more question, can I apply this measure to calculate the previous month's forecast? I tried the following but it returns the same results:

 

=CALCULATE([Forecast - Revenues],DATEADD(Data[Forecast Date],-1,MONTH))

 

Thanks again!

az38's avatar
az38
Community Champion
6 years ago

Cali_2020 

try

var _maxPrevDate = CALCULATE(MAX(Data[Forecast Date]),Data[Forecast Date]<=EOMONTH(TODAY(),-1))

 

do not hesitate to give a kudo to useful posts and mark solutions as solution

  • Cali_2020's avatar
    Cali_2020
    Helper I
    6 years ago

    az38 - worked like a charm! Thank you!!!

    • az38's avatar
      az38
      Community Champion
      6 years ago

      Cali_2020 

      thx! good luck, welcome to power bi world!

       

      do not hesitate to give a kudo to useful posts and mark solutions as solution