Forum Discussion
Query on PreviousWeek Function
Hi Team,
I have used PREVIOUSDAY, PREVIOUSMONTH, PREVIOUSQUARTER & PREVIOUSYEAR function as well. However, unable to find PREVIOUSWEEK function. Just wanted to know why we don't have Previousweek function in DAX. Any specific reason?
Regards,
Vikas Singh Jayara
Hi Vikas_Jayara12 ,
As far as I know, there isn't a DAX formula to calculate data in previous week. I suggest you to add a [Start Date] which is mentioned by the blog shared by ribisht17 to determind the week.
DimDate Table:
DimDate = VAR _BASIC = ADDCOLUMNS( CALENDARAUTO(),"Year",YEAR([Date]),"Month",MONTH([Date]),"WeekNum",WEEKNUM([Date],2)) VAR _ADD = ADDCOLUMNS(_BASIC,"Start Date",[Date] - WEEKDAY([Date],2)+1) Return _ADDThen create a measure based on DATEADD() function.
Last Week Sales = CALCULATE(SUM('Table'[Sales]),DATEADD(DimDate[Date],-7,DAY))Best Regards.
2 Replies
Please find this blog / solution Solved: Calculate previousweek performance starting monday - Microsoft Power BI Community
Thanks,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau UsersHi Vikas_Jayara12 ,
As far as I know, there isn't a DAX formula to calculate data in previous week. I suggest you to add a [Start Date] which is mentioned by the blog shared by ribisht17 to determind the week.
DimDate Table:
DimDate = VAR _BASIC = ADDCOLUMNS( CALENDARAUTO(),"Year",YEAR([Date]),"Month",MONTH([Date]),"WeekNum",WEEKNUM([Date],2)) VAR _ADD = ADDCOLUMNS(_BASIC,"Start Date",[Date] - WEEKDAY([Date],2)+1) Return _ADDThen create a measure based on DATEADD() function.
Last Week Sales = CALCULATE(SUM('Table'[Sales]),DATEADD(DimDate[Date],-7,DAY))Best Regards.
