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