Getting previous week Value in Sales report

[Bhuvaraghan]

Hi All,

I am preparing a sales report where I want to show accounts which moved from one stage to another in the previous week.

Week	Stage	Account Name	Previous Week
10/16/2020	Proposal Submitted	ABC	-
10/16/2020	Discovery	XYZ	-
10/23/2020	Contract Negotication	ABC	Proposal Submitted
10/23/2020	Discovery	XYZ	Discovery
10/30/2020	Won	ABC	Contract Negotication
10/30/2020	Proposal Submitted	XYZ	Discovery

I want to calculate the Previous week column using DAX. Any help is appreciated. If I need to create any helper columns to identify previous week also, I can do.

Thanks,

Bhuvaraghan

[Icey]

Hi @Bhuvaraghan ,

You can also create a column like so:

Column =
CALCULATE (
    MAX ( 'Table'[Stage] ),
    FILTER (
        'Table',
        'Table'[Account Name] = EARLIER ( 'Table'[Account Name] )
            && 'Table'[Week]
                = EARLIER ( 'Table'[Week] ) - 7
    )
)

It works the same as what @amitchandak provided.

Best regards

Icey

If this post helps,then consider Accepting it as the solution to help other members find it faster.

[Bhuvaraghan]

Thanks a lot, worked like a charm 🙂

[amitchandak · Accepted solution]

@Bhuvaraghan , Try a new column like

maxx(filter(table, [Week] = earlier([Week])-7 && [Account ] = earlier([Account ])),[Stage])

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.

[Bhuvaraghan]

Thanks a lot for your help 🙂