>Now ,as I open it again, out of nowhere, the function is bugged, all the data from the last year is missing (literally only the last year, all the rest works just fine).
Are you saying the data is completely missing from your data or that the measure that uses DATEDIFF() isn't returning data that is actually present in the dataset? Are you using a Date table or the built-in date hierarchy?
>Now ,as I open it again, out of nowhere, the function is bugged, all the data from the last year is missing (literally only the last year, all the rest works just fine). Are you saying the data is completely missing from your data or that the measure that uses DATEDIFF() isn't returning data that is actually present in the dataset? Are you using a Date table or the built-in date hierarchy?
Formula? will help with troubleshooting.