How to divide values ​​in a table by the last row

[stiguuuu]

Hello,

I have a table with Data and total Sales in each month (name of monhts in polish language).

I want to add a column (by measure) in my table includes:

for each month, divide the value of the last month in the table (in this case it is March) and the value for the selected month.

for example:

- in January 2023, the sales value from March 2024 (last month) divided by the sales value from January 2023

- in February 2023, the sales value from March 2024 (last month) divided by the sales value from February 2023

Thanks for all tips how I can do that measure.

Regards,

Tomasz

[stiguuuu]

Thank you for your answer.

I tried what you wrote about and actually when I want to display the result in the MAX date value tab, it shows the value from the last month and it is ok.

The problem occurs when such a measure is inserted into the table as a column. MAX date is read as a value from a particular month, not the last one in the entire table. Each month itself is MAX (not the last one in the table)

[Anonymous · Accepted solution]

Have you tried declaring a variable of LastMonth = MONTH(TODAY() -1) or DATEADD?  The functions should not be affected by the row context. Then you can use the MAX at the row level for dividing by the declared variable

[stiguuuu]

I did it on my own and works but thank you for your tips guys. Below details

[lbendlin]

read about ALLSELECTED

[lbendlin]

- find the MAX date in your current filter context

- find the value for that date (for example via CALCULATE)

- DIVIDE the result by the value for the "current"  row