https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Prev-Day-and-WTD-with-year-slicer/m-p/3240566#M119215 <P>Hi,&nbsp;</P><P>&nbsp;</P><P>I have a table visual where the columns are customer counts for the Previous Day, WTD, MTD, QTD and YTD.</P><P>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.<BR /><BR />These are my existing measures for the current year, I might be on the wrong track entirely with both of these<BR /><BR /></P><LI-CODE lang="markup">New Members Previous Day = CALCULATE([New Members], 'Member_Events'[Date] = TODAY()-1)</LI-CODE><LI-CODE lang="markup">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))</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>New Members is just a count of customer numbers with a few filters applied, coming from the Member_Events table. TIA</P> Wed, 17 May 2023 15:18:02 GMT Anonymous 2023-05-17T15:18:02Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Prev-Day-and-WTD-with-year-slicer/m-p/3240566#M119215 <P>Hi,&nbsp;</P><P>&nbsp;</P><P>I have a table visual where the columns are customer counts for the Previous Day, WTD, MTD, QTD and YTD.</P><P>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.<BR /><BR />These are my existing measures for the current year, I might be on the wrong track entirely with both of these<BR /><BR /></P><LI-CODE lang="markup">New Members Previous Day = CALCULATE([New Members], 'Member_Events'[Date] = TODAY()-1)</LI-CODE><LI-CODE lang="markup">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))</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>New Members is just a count of customer numbers with a few filters applied, coming from the Member_Events table. TIA</P> Wed, 17 May 2023 15:18:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Prev-Day-and-WTD-with-year-slicer/m-p/3240566#M119215 Anonymous 2023-05-17T15:18:02Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Prev-Day-and-WTD-with-year-slicer/m-p/3240608#M119223 <P>Hello,</P><P>&nbsp;</P><P>Please provide some dummy data alongwith desired output. Thanks!!</P> Wed, 17 May 2023 15:35:47 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Prev-Day-and-WTD-with-year-slicer/m-p/3240608#M119223 Ajendra 2023-05-17T15:35:47Z