Search:

Type: Posts; User: cr731; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    1
    Views
    92

    Does 'On Error Resume Next' reset error?

    I am using On Error Resume Next within a for...next loop, and need to check if an error occurs within each loop. I'm wondering if the On Error Resume Next statement itself clears any existing error?...
  2. Re: Power Query Conditional Sort Based on Column Value

    Maybe I'm missing something, but doesn't that just sort ascending by Type?
  3. Re: Power Query Conditional Sort Based on Column Value

    Sorry, that was just a typo in my example. My actual query did use Order.Ascending.
  4. Power Query Conditional Sort Based on Column Value

    I have a table containing a column called "Type" and I want to sort the rows of the table differently based on the value in that column. For example,

    if Type = "A" then sort by {{"Column1",...
  5. Replies
    1
    Views
    138

    Excel VBA Immediate Window Question

    When using the Immediate Window in the VBA editor, if running a macro from one of the open workbooks, is it possible to specify which workbook it runs from instead of having to click into the project...
  6. Finding most recent entry with criteria in Power Query

    I am struggling with a Power Query performance problem and have exhausted all of my ideas, so I am hoping someone here may have an idea.

    I have two tables:
    - Fact table containing sales data:...
  7. Replies
    2
    Views
    463

    Re: Possible to return error values in PQ?

    Thanks; that is exactly what I needed.
  8. Replies
    2
    Views
    463

    Possible to return error values in PQ?

    I am using Power Query to review an Excel file and look for any error values (such as #NA , #VALUE , etc.).

    When PQ imports these, it converts the cell to Error. If returned to the Excel...
  9. Replies
    2
    Views
    1,647

    Power Query Sort Ascending, Null Last

    In Power Query, I have a column of date values that I want to sort ascending. In some cases, I have null values. I want null to be last, but Order.Ascending results in null values being at the top....
  10. Replies
    4
    Views
    516

    Re: PQ Dynamic Add Merge Column

    Wow, that made all the difference. Same speed as the original now. Thanks!
  11. Replies
    4
    Views
    516

    Re: PQ Dynamic Add Merge Column

    KeyColumns_List is an Excel table loaded to Power Query (and then converted to a list). The idea is that I want to make it easier for users to maintain the columns that should be merged to create a...
  12. Replies
    4
    Views
    516

    PQ Dynamic Add Merge Column

    In Power Query, how can I add a column which merges columns based on a list (so the list of column names gets merged)?


    If done manually, I would have



    let
    Source = Input_Original,
    ...
  13. Replies
    1
    Views
    243

    UserForm Level Variables Scope Question

    I have several variables declared at the top of my UserForm (outside of any procedure), some of them are ranges, ListObjects, and PivotTables. Is it necessary to use


    Set variable = nothing
    ...
  14. Replies
    1
    Views
    284

    VBA Editor - Collapse by Default?

    In the Excel VBA editor window, is there a way to have it open with all projects collapsed by default?

    Every time I open the window to edit a macro, my Personal XLSB file shows fully expanded,...
  15. Replies
    3
    Views
    550

    Re: PQ List.Transform Question

    Thanks for the response, and sorry my question was not clear.

    I'm trying to create a function that takes a table and list of column names as parameters and merges columns of the source table based...
  16. Replies
    3
    Views
    550

    PQ List.Transform Question

    I have a step in my query which contains a list of field names


    = {"Customer", "Product"}

    I want to transform this list into a list of lists, it should look like the following



    {
  17. Re: Is it possible to create named constants in Power Query

    Just to clarify what I'm looking for: I want to create a custom function with an optional parameter, very much like Table.Sort where Order.Ascending and Order.Descending are optional, and the default...
  18. Is it possible to create named constants in Power Query

    I'm wondering if it's possible to create your own named constants in PQ, like Order.Ascending (which equals 0) and Order.Descending (which equals 1)?

    Thanks
  19. Replies
    2
    Views
    1,641

    SUMX Over Multiple Columns

    I am using SUMX to sum a calculation by Order Number in my table, and I want to add a new calculation that iterates over both Order Number and Item Number in my table, but having trouble doing so.
    ...
  20. Re: PQ Easiest Way to Set Table2 Column Types equal to Table1?

    Thanks - Value.ReplaceType is what I was missing.

    One thing though - if Table1 has a column with type date, that column in Table2 becomes type datetime, which isn't really what I would want when...
  21. PQ Easiest Way to Set Table2 Column Types equal to Table1?

    I have two tables, Table1 and Table2, and I want to set all of the column types of Table2 the same as Table1. All columns will be the same. What's the easiest way to do this? I was thinking of...
  22. Replies
    2
    Views
    498

    PQ Performance in Comparing Two Tables

    I am using Power Query to compare column values in two tables, where each table has a Key column as well as around 20 dimension columns, which I want to check to make sure that the dimensions align...
  23. Replies
    2
    Views
    337

    Re: VBA Workbooks.Open - If Already Open?

    Thanks; I did do some similar searches before posting but I guess my question really is, does it matter if the workbook is already open before running Workbooks.Open? I found lots of questions...
  24. Replies
    2
    Views
    337

    VBA Workbooks.Open - If Already Open?

    If I use
    Workbooks.Open "My File Name" and the workbook is already open, will it re-open the file (wasting time for a large file) or will it just do nothing since the file is already open?

    I...
  25. Creating Prioritized/Exception-Based Mapping in PQ

    I have a requirement to create a mapping table that is based on 4 columns of my source data where the mapping can occur at 1 or a combination of multiple of those 4 columns. More specific rules...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4