• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Compare Data each Refresh

Poolman7

New Member
I have a simple Excel sheet that gets updated and changed during the day. Any ideas on how I have can get a visual that shows the comparisons of each refresh? There is not a date/time column in my data source. It is simple data...a list of cars. This changes every day and I need to see those changes. (20 down to 16 as an example.) But my 20 does not exist once the list is updated. It only shows a current list of cars at 16. Could Power Bi add a date column every time I hit refresh? I need Power Bi to remember the previous values. Ideas? Help.

CompanyCars
Blue2
Green4
Red6
Yellow8
 
Does this have to be Power Bi? If not, then this simple macro will work:
Code:
Sub Shift()  'Run this however many times you need the data to be shifted
    Columns("A").insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
End Sub
My apologies if I misunderstood the question
 
Back
Top