Forum Discussion

telesforo1969's avatar
telesforo1969
Helper V
1 year ago
Solved

Calculate Projection

I need your help with the following: I need to calculate the projection of a value as follows: the immediate previous value times the rate for the month to be calculated. Once the previous value is c...
Need Help
  • v-aatheeque's avatar
    v-aatheeque
    1 year ago

    Hi telesforo1969 ,

    Thanks for sharing the screenshots. as you need you can achieve the calculation of future values with the following DAX measures:  

    Inflation Rate  =
CALCULATE (
    PRODUCT ( Values[Inflation Rate] ),
    FILTER (
        ALL ( Calender ),
        Calender[Date] <= MAX ( Calender[Date] )
    )
)

    Future Values : 

    Future_Value =
MAX ( Values[Value] ) * [Cumulative_Inflation]


    Hope this helps !!



Ashish_Mathur's avatar
Ashish_Mathur
Super User
1 year ago

Hi,

I am not sure how much i can help but i'd like to try.  Share the download link of the PBI file.  If possible, please have column names in English.