Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: Error: We Cannot Convert a value of Type Function to Type list

    I've had this problem before and it was because you were using a table instead of a list.
    Click on the query column heading and select drill down.
  2. Looking for good Power Query Websites and Resources

    Hi All,

    Can you please share some good websites which you've come across to learn Power Query? I'm finding a lot of excel websites, but they hardly cover Power Query.

    I currently own the...
  3. Re: Can I unpivot multiple non-contiguous rows to columns?

    I was able to download from post#20.

    Thanks for you patience.
  4. Re: Can I unpivot multiple non-contiguous rows to columns?

    Thanks. I've tried everything suggested an its not working.

    Can you please share the M code you use so that I can attempt to recreate it?

    Thanks.
  5. Re: Can I unpivot multiple non-contiguous rows to columns?

    Tried that. Still did not work.
    I was able to open the original file from the poster without any difficulty.
  6. Re: Can I unpivot multiple non-contiguous rows to columns?

    When I click open in desktop App nothing happens.
    Is it possible for you to share via google drive, drop box, or another alternative to onedrive?
  7. Re: Can I unpivot multiple non-contiguous rows to columns?

    @sandy666,

    Is your result file still available? I'm unable to open it in any of by browsers (chrome, IE, Opera) neither as an online version nor download it.

    I'm interested in seeing the...
  8. Re: Vlookup vs. relationships between two tables or more

    Look into power query Merge feature. You should also look into the append feature.
  9. Re: Can I unpivot multiple non-contiguous rows to columns?

    @Mark_E

    Can you use the insert link feature ( the globe next to the smiley face) to share a picture of what the results should look like in excel?

    Should the original data look like this?
    ...
  10. Re: Power Query - How to reference a column position in a formula

    alansidman,

    Sorry for the confusion, but its working.
    The error was on my end. It pasted your coded into prior version of the workbook I had.

    Thanks for your help with this.
  11. Re: Power Query - How to reference a column position in a formula

    sandy666,
    The error was on my end. It pasted your coded into prior version of the workbook I had.
    Its working now, sorry for the confusion.

    However, I think a tweak was needed on your M code on...
  12. Re: Power Query - How to reference a column position in a formula

    sandy666,

    I'm getting an error at the Filter step (see below). What is [Month} referring to?

    Expression.Error: The field 'Month' of the record wasn't found.
    Details:
    Name=A
    ...
  13. Re: Power Query - How to reference a column position in a formula

    alansidman,

    I copied and pasted your code as is.
    I'm getting this error at the Pivoted column step "Expression.Error: The column 'Month' of the table wasn't found.Details:
    Month

    What is...
  14. Re: Power Query - How to reference a column position in a formula

    Columns A to C is the original Data.
    My desired results are in E to H


    <colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>

    A
    B
    C
    D
  15. Re: Power Query - How to reference a column position in a formula

    I keep getting a error.
    Also, if the column is demoted wouldn't this result in text being calculated and numbers and create errors?
  16. Power Query - How to reference a column position in a formula

    Hi guys

    Just as a simplified example

    I have the following data

    Column A Col B Col C
    Product May June
    Item1 5 2...
  17. Re: Related tables - two tables that won't relate

    What should the desired results look like?
  18. Re: Power Query / DAX solution to Excel formulas (or if this is even appropriate)

    You can use Power Query feature found under Add Column -> then select Custom Column. All the if formulas you have in column V to Y can be done using the custom column feature.
    This website gives...
  19. Replies
    3
    Views
    1,075

    Re: Combine 2 tables

    I don't fully understand the question, but I would suggest you look into Power Query Merge or Append feature. Either of those would be your solution.
  20. Re: Power Query slows down after merging queries or tables

    The key appears to work, but I'll not fully know until tomorrow.

    Can you help me understand the primary key please. When I researched it, the syntax was

    Table.AddKey(table as table, columns...
  21. Re: Power Query slows down after merging queries or tables

    Thanks. I"ll try this. I did not create the code by writing/coding. All I did mostly was using the point and click feature. I'm still learning power query and I'm not advance enough to be writing...
  22. Re: Power Query slows down after merging queries or tables

    Just to make sure I understand as the file is really slow.

    For prior year

    Prior Year Query code



    let
    Source = Folder.Files("C:\Users\..........................."),
  23. Re: Power Query slows down after merging queries or tables

    Both Queries are slow. The Current Year was the slowest at first, however when I completed the current year and merged it with Prior year as then needed a field from the Current Year, the Prior Year...
  24. Re: Power Query slows down after merging queries or tables

    How do I use key tags?

    The primary key is not in this code. I was trying it after the query kept slowing down but I was not able to save it because of how long it took.
  25. Re: Power Query slows down after merging queries or tables

    Peter, do you mind expanding a bit on how best to do this? I tried it, however so much information was filtered out that I was not able to verify along the way if my steps were correct as too much...
Results 1 to 25 of 80
Page 1 of 4 1 2 3 4