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



telesforo1969's avatar
telesforo1969
Helper V
1 year ago

I need help calculating future data. The formula is shown in the red box. I have a calendar table because I'm calculating my rate with my calendar table. I just need help calculating future values ​​using the rate.

 

 

 

v-aatheeque's avatar
v-aatheeque
Community Support
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 

    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.