Forum Discussion
Solved
Last year from max date
Hi, I was doing some calculations, and in this one I use a filter to select the max date : date = MAX(Date[Dates]), Now I need te value from the same date but in the last year, I have tried ...
you can try 'lydate = MAX(Date[Dates])-365' or you can try the DATEADD function
This is not valid syntax - you seem to be mixing inbuilt time intelligence with custom time intelligence. It seems you have a calendar table. The date from the calendar table needs to be in your visual. Then you could write this
=calculate([measure],sameperiodlastyear(date[date]))
read my article here https://exceleratorbi.com.au/dax-time-intelligence-beginners/