Get the price update factor


#1

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

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.


#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