Get the price update factor

DAX DAX Calculations
1

Hello. I need to get a price update factor from the following table.

image
image.png984×827 33.8 KB

Now I need to add a column to this table, that obtains the division between January/15 with January/18, January/16 with January/18… that is to say, divide each month with its corresponding to the last year.

image
image.png1027×478 51.2 KB

2

It there any reason you can’t do this in DAX?

It would be so simple using DAX because you could just use easy time intelligence techniques and layer them all into the one measure using variables.

You would only really need to use DATEADD.

Can you do that? Does it have to be done in a table here?

How are you going to use this number ultimately?

Thanks