Forum Discussion

lrhoffer's avatar
lrhoffer
Regular Visitor
9 years ago

Finding Value Change between Months

I'm trying to calculate the change in price from one month to the next (Ex. September Price minus August Price). I have a column that shows: 201708,201709,201710, etc... The column beside it shows th...
Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

lrhoffer

In "Query editor", you first add suffix 01 to each "date".

 

 

Then convert that column as date.

 

The last step, right click and remove errors.

lrhoffer's avatar
lrhoffer
Regular Visitor
9 years ago

I've heard that if you edit information in query editor, it makes automatic updating more difficult. Do you think this might cause problems with the automatic updating aspect?

  • Eric_Zhang's avatar
    Eric_Zhang
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago
    lrhoffer wrote:

    I've heard that if you edit information in query editor, it makes automatic updating more difficult. Do you think this might cause problems with the automatic updating aspect?

    lrhoffer

    I've not encountered any problem on automatic updating.