+ Reply to Thread
Results 1 to 4 of 4

Power Query Add Column try _

  1. #1
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    768

    Power Query Add Column try _

    Hi,
    I would like to add error information to a column, so my starting point is ;

    Please Login or Register  to view this content.

    But I want to get to the infomation in the Value Record. I have tried

    Please Login or Register  to view this content.
    but this does not work? I have drilled down in the example to, but I would like this or similar as an added column

    If someone knows a blog please let me have the site / link,

    Sorry this is a bit vague. I've attached work book showing what I would like to get in the column.

    Richard.
    Attached Files Attached Files

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,973

    Re: Power Query Add Column try _

    Not sure what you want to do... but something like this will return Error Record's Message.
    Ex:
    Please Login or Register  to view this content.
    So using try will return operation result as record, [HasError] Boolean, [Error] record and [Value].
    Now you want to handle if [HasError] is true to return [Error] record's specific field. "Reason", "Message" and "Detail" are available. "Detail" could also be record.
    If not then return [Value] field. Or you can just use try [Unit] - [Sales]. Then expand column to obtain all fields.
    "Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
    ― Robert A. Heinlein

  3. #3
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    768

    Re: Power Query Add Column try _

    Oh, just to add I would give you a 'rep' but it won't let, so you'll have to make do with thanks.

    RD

  4. #4
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,973

    Re: Power Query Add Column try _

    You are welcome

+ 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. Replies: 3
    Last Post: 03-01-2024, 03:59 AM
  2. Replies: 1
    Last Post: 07-14-2023, 10:15 AM
  3. [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
  4. Replies: 10
    Last Post: 06-25-2020, 12:19 AM
  5. Custom Permutations Column in Power Query from two columns in the same Query
    By PaintPaddy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2019, 02:48 PM
  6. [SOLVED] Power Pivot does not load new column added in Power query
    By ibuhary in forum Excel General
    Replies: 12
    Last Post: 02-19-2019, 03:53 AM
  7. 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

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