Last 12 months

[NewbieJono]

i have a dataset that is always a couple of months behind e.g the last data point was 01/07/2024 and this can vary depending on when we get the data.

is there a method to show the last 12 months from the last data point? e.g in the case it would be Aug 2023 - Jul 2024

[Smalfly · Accepted solution]

Hi @NewbieJono ,

here is an article about calculating the last 12 months that might be helpful for your case:

https://gorilla.bi/dax/5-ways-to-calculate-last-12-months-in-dax/