Hi,
I have a table visual where the columns are customer counts for the Previous Day, WTD, MTD, QTD and YTD.
I'd like to add a year slicer on the page to look back over the last couple of years. MTD, QTD and YTD all work fine with the slicer as they're the built in to date functions, but I'm having trouble getting the first two to work. I could use DATEADD or similar to get it in a separate measure but I'd like to just use the one measure and have the table update dynamically with the slicer if possible.
These are my existing measures for the current year, I might be on the wrong track entirely with both of these
New Members Previous Day =
CALCULATE([New Members], 'Member_Events'[Date] = TODAY()-1)
New Members WTD =
var CurrentDate = LASTDATE('Date'[Date])
var DayNumberOfWeek = WEEKDAY(LASTDATE('Date'[Date]),2)
return
CALCULATE([New Members], DATESBETWEEN('Date'[Date], DATEADD(CurrentDate,-1*DayNumberOfWeek,DAY),CurrentDate))
New Members is just a count of customer numbers with a few filters applied, coming from the Member_Events table. TIA
