Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.05 seconds.

  1. Power Query Transforming Column with Actual and Budget Amounts

    I have the following three columns of data in Power Query that looks like this:

    Category...……….Month...……..............Amount

    Sales...…………….Jan Actual...……………......$100
    Sales...…………….Jan...
  2. Re: Power Query Does Not Import Multiple PDF Pages

    I have 235 PDFs, manually adding as new query will take too much time. That's a great idea about merging the PDFs with Adobe Acrobat (which I have). Let's see how it turns. Stay tuned. Thanks!
  3. Re: Power Query Does Not Import Multiple PDF Pages

    When I right click and Drill Down the Content column it creates a List in one column and I can drill down any of the Binary and expand the table objects, but I can't seem to drill down all of Binary...
  4. Re: Power Query Does Not Import Multiple PDF Pages

    Yeah, I just want to combine all table objects from PDFs from a folder. The columns of the tables is in the Contents column which when I expand only shows the records of the first table object of...
  5. Re: Power Query Does Not Import Multiple PDF Pages

    I don't want to assume what you know or don't know, so I like to describe in detail what I'm observing so you or anyone else can comprehend the issue. Kind of like your quote "I know you know but I...
  6. Re: Power Query Does Not Import Multiple PDF Pages

    Once I connect via "Folder" data source I can select Combine, Load, or Transform.

    If I select Combine it will allow for either "combine & transform" or "load". If I select "combine &...
  7. Re: Power Query Does Not Import Multiple PDF Pages

    I think I see the problem. I'm not technically connecting using "PDF" data source, I'm using "Folder" and when I do that it shows PDF file with 10 objects, of which 5 are tables (the one's I need to...
  8. Re: Power Query Does Not Import Multiple PDF Pages

    So you can see all the records once you connect to the single PDF, including the last record on the last page?

    Why do you find PBD useless? I don't think Power Query for Excel can connect to a PDF...
  9. Power Query Does Not Import Multiple PDF Pages

    Hi,

    I'm using Power Query for Power BI Desktop and when I connect to a single PDF file the last record only shows the data for the first page and not the rest of the pages. The rest of the data...
  10. Re: Power Query to Concatenate Rows Based on Condition

    NVM, I was able to apply CLEAN and it worked. TRIM did not work.
  11. Re: Power Query to Concatenate Rows Based on Condition

    Thank you both. I used your method as it was easy for me to understand and change the M code. Small issue, some address lines show like this in a cell:

    123 Moonlight St.
    Columbus, OH 57423
    ...
  12. Re: Power Query to Concatenate Rows Based on Condition

    So I did Group By on the ID field > All Rows, but I don't know how to apply the List.Distinct? Should I expand the new column once I did Group By? Where do I use List.Distinct? In a Custom Column?
  13. Power Query to Concatenate Rows Based on Condition

    Hi,

    I have column with Names, (unique) ID, and Address. The problem is some addresses have their street address in one row and the row below it is their city, state and zip. I would like to have...
  14. Replies
    8
    Views
    1,333

    Re: Insert New Row in Excel Power Query

    Worked beautifully. Used Table.InsertRows method since it's less line to type. Thanks.
  15. Replies
    8
    Views
    1,333

    Re: Insert New Row in Excel Power Query

    Do I need to convert my table to a list before I can use Table.FromRecords or Table.InsertRows? How would I do that? I'm trying to add the new record (on the very top, base zero) in the Advanced...
  16. Replies
    8
    Views
    1,333

    Re: Insert New Row in Excel Power Query

    If I append, will the record show at the end or the first row of the original table? If the the former is true, then how would I bring the last row as the first row? Thanks.
  17. Replies
    8
    Views
    1,333

    Insert New Row in Excel Power Query

    I have a table with 15 columns in Excel Power Query and want to add a new first row in my table called "Summer", but I only want "Summer to appear in column 1, row 1 and the rest of the row should be...
  18. Re: DAX: Running Total on Non-Date Column

    The pivot table example should say $130,000 for first line of the Running Total (not $140,000)
  19. DAX: Running Total on Non-Date Column

    I have a data model pivot table with a column named "2019 Actual" which shows sales amount. The column resides on the "CombinedAllYears" table. I don't technically have dates (4/1/2019, 4/2/2019,...
  20. Macro To Changes Tab Names Based on Cell Value

    I need help with a macro that will change all the tab names of my worksheets based on the left 4 characters (they are generally numbers and has a leading zero) from the value in cell A4. If there is...
  21. Replies
    4
    Views
    757

    Re: Power Query Nest If Statement

    Was able to figure using Conditional Column button in Power Query, it's a intuitive user interface for creating the nested IF statement I was looking for. Thanks!
  22. Replies
    4
    Views
    757

    Re: Power Query Nest If Statement

    Thanks for taking to time to look into this but I was just looking to a create a Custom Column in Power Query because I already have other columns in my Excel and wasn't trying to create a separate...
  23. Replies
    4
    Views
    757

    Power Query Nest If Statement

    I need to create a nested if statement as a custom column using the Month column (3 letter abbreviation) to create a an integer for each month like below. How would I create this nested if...
  24. Re: Power Query to Get Fiscal Year & Fiscal Month

    Was able to figure it out by changing it to the following. Thanks again!

    = Table.AddColumn(#"Inserted Day Name", "Fiscal Month", each if Date.Month([Date]) >=10 then Date.Month([Date])-9 else...
  25. Re: Power Query to Get Fiscal Year & Fiscal Month

    Ah! Didn't read that. I got the fiscal year correct but I'm having trouble with the following part to get the correct fiscal month



    = Table.AddColumn(#"Inserted Day Name", "Fiscal Month", each...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4