Help with DAX - MoM% - Compare with last month that presents data

[yagorsrocha]

Good morning,

I have a problem, I cannot perform a month-over-month comparison using the last month that presents data. Like, June over February, etc.

I need to perform MoM% separately for each item.
Ps: My months are in Portuguese. lol

And the fields are:

[lbendlin]

Divide your problem into smaller steps.

- for each row find the item id and the month

- in the entire table find the row for the same item that has the maximum month value smaller than the current month

- get the monetary value for that row

- do your MoM calculation.

This is best done with variables, and frequent debug checks to make sure the intermediate steps return the right result.