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



Greg_Deckler's avatar
Greg_Deckler
Community Champion
1 year ago

telesforo1969 This looks a bit like a recursive calculation which can be problematic for DAX. For the next line (ago), would the next cell's calculation be the result of the calculation in the red box multiplied by the .002954 number? Are you able to post your date as text that can be copied?

 

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

  • 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?