Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

  • Anonymous's avatar
    Anonymous
    6 years ago

    I figured it out . Keep last three rows and then delete last 2

    thanks

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    I figured it out . Keep last three rows and then delete last 2

    thanks