Current Week and Previous Week

[Neelofar_Shama]

Hi,

I have a report requirement where I want to display current week sales and previous week sales. I have created a date table can you please help me with the DAX for current week and previous week.

Thanks in Advance,

Neelofar.

[v-rongtiep-msft · Accepted solution]

Hi @Neelofar_Shama ,

Please have a try.

Create 2 columns.

Current Week Sales =
VAR CurrentWeek =
    WEEKNUM ( TODAY () )
RETURN
    CALCULATE (
        SUM ( Sales[Sales Amount] ),
        FILTER ( Sales, Sales[Week Number] = CurrentWeek )
    )

Previous Week Sales =
VAR CurrentWeek =
    WEEKNUM ( TODAY () )
VAR PreviousWeek = CurrentWeek - 1
RETURN
    CALCULATE (
        SUM ( Sales[Sales Amount] ),
        FILTER ( Sales, Sales[Week Number] = PreviousWeek )
    )

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ritaf1983]

Hi @Neelofar_Shama 

Please refer to these tutorials :

https://www.youtube.com/watch?v=_j6Okp7zQlE

https://www.youtube.com/watch?v=kqr5iyd55Og&t=9s

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly