DAX function Previous

[Asad92]

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

[Ashish_Mathur]

Hi,

In most cases, the DATESBETWEEN() function can also be used.  You need to share more data, describe your question and show the expected result.

[ronaldbalza2023]

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 Sales