Forum Discussion
Adjustable Same Periodlastyear function?
HI, I am using the function 'Sameperiodlastyear' and I know about 'dateadd' I have a chart that looks like this: However, my issue is that Thanksgiving falls on a different days of ...
You could make a disconnected table with GENERATESERIES(-10,10,1), for example and use the Value column from that in a slicer as your # of days to offset. You can then use EDATE(MIN(Date[Date]), -12) + SELECTEDVALUE(Offset[Value]) in a variable for your min date, do the same for max date and use those two variables in your CALCULATE filters to get the same period last year w/o time intelligence.
Or you could wrap SAMEPERIODLASTYEAR with DATEADD and use the SELECTEDVALUE as the days to offset in DATESADD.
Pat
Ok, thank you... let me give it a shot....I don't consider myself a Dax Pro. 😅