+ Reply to Thread
Results 1 to 3 of 3

Power query - determine conditional difference

  1. #1
    Registered User
    Join Date
    07-29-2018
    Location
    In the Queen's Shed
    MS-Off Ver
    2013
    Posts
    23

    Power query - determine conditional difference

    I've loaded a .csv file which contains data from 4 sensors. Example below: the .csv data I've loaded using Powerquery consists of 3 columns "Time", "Source" and "Value". I aim to get the changes in the "Values" column to a new column called "Delta", using Powerquery. I have not been very successful so far. How to do this?

    Time Source Value Delta
    00:00 Sensor A 150 150
    00:00 Sensor B 20 20
    00:00 Sensor C 50 50
    00:00 Sensor D 80 80
    00:05 Sensor A 120 -30
    00:05 Sensor B 25 5
    00:05 Sensor C 60 10
    00:05 Sensor D 90 10
    00:10 Sensor A 100 -20
    00:10 Sensor B 40 15
    00:10 Sensor C 60 0
    00:10 Sensor D 105 15

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,371

    Re: Power query - determine conditional difference

    There are instructions at the top of the page explaining how to attach your sample workbook.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    07-29-2018
    Location
    In the Queen's Shed
    MS-Off Ver
    2013
    Posts
    23

    Re: Power query - determine conditional difference

    *bumperty-bump*

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Difference between connections and queries using VBA to create Power Query
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-11-2021, 05:57 AM
  2. [SOLVED] Power Query/Power Pivot Conditional Column creation & chart
    By mz_h in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-12-2020, 06:07 PM
  3. Replies: 6
    Last Post: 10-16-2020, 05:44 AM
  4. Replies: 10
    Last Post: 06-25-2020, 12:19 AM
  5. Replies: 4
    Last Post: 02-17-2020, 06:03 AM
  6. Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)
    By chullan88 in forum Suggestions for Improvement
    Replies: 10
    Last Post: 06-28-2018, 02:25 PM
  7. Replies: 3
    Last Post: 12-03-2017, 01:41 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1