Forum Discussion
Anonymous
6 years agoNot applicable
Calculated column for data from 2 weeks back
Hello experts,
need some help. I have column names as different dates and rows with properties as I calculate the weekly difference b/w properties. Now how can I make it dynamic? I made it work for current week by introducing another table in power query, pivoting the table and keep last row from bottom. How do I make it work for current week -2?
any help here? Thanks
- Anonymous6 years ago
I figured it out . Keep last three rows and then delete last 2
thanks
1 Reply
- AnonymousNot applicable
I figured it out . Keep last three rows and then delete last 2
thanks