Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

PQ create log of changes

Hi, 

I have numerous reports that are generated each day and always have same table like structure. Each row in those reports shows values for unique ID's (like temp1, temp2, temp3, ...). What I need to have as result is table of changes per each ID, field that changed, old value (from most recent previous date) and "new" value. I have no idea how to do this in Power Query, please advice. Sample file is attached Sample

Thanks

4 Replies

  • Hi, Anonymous 

     

    I dont really understand very well but...

     

    It would work something like this?

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      No, result should look like this

       

      • Anonymous's avatar
        Anonymous
        Not applicable

        I would except python script in Power Query if there isn't any other solution. I know how to code this in VBA, but I can't wrap my mind around Power Query functional approach.

         

  • Hi,

     

    Are you particlar about using M to solve this problem.  Would you be OK with a M and DAX combination solution?