Evolution of consumption

Could you help me find the DAX formula that would allow me to obtain the result for column E?

data Test.xlsx (14.4 KB)

I would like to see the evolution of consumption since 1965.

Thank you

@Remi10 ,

Just need to change a context and divide as you want.
You can check formulas under New metrics folder in PBI

Test_1.pbix (23.2 KB)

Hope it helps.

Thank you very much for your help.

1 Like

I would like to modify the increments of the x-axis for the years. I want the years to be in increments of 5 instead of 10. Could you please help me?

Hi @Remi10 ,

Currently in PBI native Line Chart we do not have the option to modify the exact range between points of the axes except for changing the start/end point. Also if you would like to have wider range you can switch Type from Continuous to Categorical.

For Paginated reports you can check at: