Forum Discussion
SAMEPERIODLASTYEAR weird behavior when including today
Hi, I have used SAMEPERIODLASTYEAR to create a measure showing me values of the previous year. Guests = DISTINCTCOUNT('Fact Guest Enquiry'[enquiry_id]) Guests Previous Year = CALCULATE(Guests,S...
zivhimmel , Make sure your date/calendar table is marked as date table. This should work with today too.
Try this type of formula
Year behind = CALCULATE([Guest]),dateadd('Dim Date'[Date],-1,Year))
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.
Thanks amitchandak . I tried your suggestions. Marked the table as a date table and tried your DAX formula.
Unfortunately it returns the same result.