dax formula

As long as you have a date table in your model you could use either CLOSINGBALANCEMONTH or CLOSINGBALANCEYEAR depending on what you're looking for.

Hi chema ,

Thanks for KNP's reply!
And chema , I created the sample data myself based on your description:

Then you can use this DAX to create a measure:

LastMonthValue = 
CALCULATE(
    MAX('Investments'[Value]),
    FILTER(
        'Investments',
        'Investments'[Month_number] = CALCULATE(
            MAX('Investments'[Month_number]),
            ALLEXCEPT('Investments', 'Investments'[Year], 'Investments'[Region])
        )
    )
)

And put the measure into the table visual, the final output is as below:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.