can excel powerquery subtract values referenced by dates? Can’t seem to ask the right question on google. I know I can write a macro to do this but I’m looking for another easy way in excel.
for example, if I have a list of dates, account numbers, and value.
I’d like to say, for account “one”, give me the difference in value between 5/16 and 5/15.
answer = +5
| date | acct | value |
|---|---|---|
| 5/16 | one | 5 |
| 5/15 | one | 10 |
| 5/16 | two | 7 |
| 5/15 | two | 14 |