Forum Discussion
Solved
Last 12 months
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
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/
1 Reply
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/