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 !!



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

Hi telesforo1969 

I wanted to check in were you able to implement the DAX measures I shared for calculating future values?

Did they work as expected in your report, or do you still need any adjustments or further help?

 

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

Hi telesforo1969 

We’d like to check if you were able to go through the previous response to your issue. Please let us know if you need further clarification we’ll do our best to support you.