Forum Discussion

telesforo1969's avatar
telesforo1969
Helper V
11 months 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
    11 months 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 !!



v-aatheeque's avatar
v-aatheeque
Community Support
11 months ago

Hi telesforo1969 

To help us reproduce and troubleshoot your scenario, we requested to share a small sample dataset/file. Could you please provide that when convenient?
It will allow us to give you a more accurate and tailored solution.