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.
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.
Thanks a lot for your help 🙂