Search:

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

Search: Search took 0.00 seconds.

  1. Re: Using Power Query to get List of column names

    Same technique but filter and keep 0 rows. Demote headers and then transpose instead of unpivot.

    But Table.ColumnNames is a quicker way to get the names.
  2. Re: Power Query in Excel refreshing after small changes in queries and very slow

    Also, I hope you don't mind the following suggestion. Your code will need to be maintained for each new period that is added. To prevent this maintenance and make your code more dynamic, I would...
  3. Re: Power Query in Excel refreshing after small changes in queries and very slow

    Hi,
    Most of my transforms are Excel and CSV. I have not found that Table.Buffer will always improve performance so I use it judiciously. And when I do use them, I put them at the end of my query.
    ...
  4. Replies
    1
    Views
    718

    Re: Looping through a table

    Hi,

    Sorry, I am not good with the formatting on the message board. And the board will not allow me to upload an attachment.

    Below is a sample table called calcs that contains Field name, the...
  5. Re: Power Query Transform & Table Formulas not propagating to new records brought in

    Hi Collin,

    Make sure that your columns FCST RE 103 and ACT RE 103 were changed type to date in your Get Data & Transform.

    Try this link to debug the formulas not filling down correctly....
Results 1 to 5 of 5