Forum Discussion
zivhimmel
Resolver I
Resolver ISAMEPERIODLASTYEAR 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...
Hi zivhimmel,
I'd like to suggest you use date function to manually defined the calculation ranges, it is more agility than time intelligence functions and not required a complete calendar table.
Time Intelligence "The Hard Way" (TITHW)
Regards,
Xiaoxin Sheng