Forum Discussion

leandroduarte's avatar
leandroduarte
Helper I
5 years ago

Inflation accumulated

Hi, I'm trying to find a solution for accumulated inflation in Dax.   This is based on the following rule   Period Inflation Accumulated Rule 1 5.7% 5.7% first row = Inflation 2 3...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi leandroduarte 

I build a measure to achieve your goal.

Accumulated = 
VAR _FirstAcc =
    SUM ( 'Table'[Inflation] )
VAR _RestAcc =
     (
        PRODUCTX (
            FILTER ( ALL ( 'Table' ), 'Table'[Period] <= MAX ( 'Table'[Period] ) ),
            'Table'[Inflation] + 1
        )
    ) - 1
RETURN
    IF ( MAX ( 'Table'[Period] ) = 1, _FirstAcc, _RestAcc )

Result:

You can download the pbix file from this link: Inflation accumulated

 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    5 years ago

    Good morning @RicoZhou , thank you very much for the contribution! I used it on my board and it works perfect!

    I have a related query, how should the measure be to visualize the cumulative total of inflation on a card? Continuing with the previous example you would need to display on a card the value 33.2%.

    Thank you so much for the help!

    Frederick

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Administrator
      5 years ago

      I share the solution I found to make it look like in the image the inflation accumulated in the last 12 months in card format:

      flitvak_0-1625086441511.png

      The measure for the card is:

      Measure name = (
      PRODUCTX(
      FILTER(all(FACT_Inflacion); FACT_Inflacion[Date] >= MIN(FACT_Inflacion[Date]));
      FACT_Inflacion[IPC - Indec] + 1
      )
      )-1

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Se você puder calcular uma inflação em duas vezes, basta mudar "ALL", para "ALLSELECTED", e criar uma caixa de filtro!!