Current Week and Previous Week

Hi Anonymous 

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

Hi Anonymous ,

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.