Forum Discussion
Solved
Getting previous week Value in Sales report
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 Proposa...
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.
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.
Thanks a lot, worked like a charm 🙂
