Forum Discussion
DAX function Previous
Hi,
I see there is no PREVIOUSWEEK function in DAX.
Could you please check and advise it there is any other alternative to calculate the previous week result.
For your ready reference, I have attached a copy of the screen image with this email.
Thanks regards,
Asad
2 Replies
Hi Asad92 , you have to make a WEEKNUM column on your date table in order to get the previous week. Check the link that might help you doing the previous week calculation. 😉
Solved: Re: Last week Dax - Microsoft Power BI Community
Solved: Re: Dax for Current Week & Previous Week - Microsoft Power BI Community
Calculate Previous Week SalesHi,
In most cases, the DATESBETWEEN() function can also be used. You need to share more data, describe your question and show the expected result.
