Evolution of consumption

Remi10 · November 16, 2023, 3:08pm

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

mspanic · November 16, 2023, 4:05pm

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

Remi10 · November 16, 2023, 4:13pm

Thank you very much for your help.

Remi10 · November 17, 2023, 8:35pm

Hi,
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?
Thanks