Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.07 seconds.

  1. Replies
    20
    Views
    723

    Re: Power Query column alignment

    you are welcome

    use solution with Parsed JSON, much easier and faster (with whole 5 GB file)

    have a nice day
  2. Replies
    3
    Views
    74

    Re: Calculation of Net Working days

    look at few posts later
    there is networkdays with hoildays
  3. Replies
    3
    Views
    74

    Re: Calculation of Net Working days

    see: Networkdays
  4. Re: Can someone help me with this? Probably a beginner level formula.

    worth to read:

    PowerQuery aka Get&Transform (links):

    What is PowerQuery
    Getting started with PQ
    PowerQuery Help
    PowerQuery M reference
  5. Re: Getting Power Query to add new values to the bottom

    you are welcome

    have a nice day
  6. Re: Can someone help me with this? Probably a beginner level formula.

    nothing wrong :)

    all what you need is Append all single tables into one (Power Query) then create Pivot Table
  7. Re: Can someone help me with this? Probably a beginner level formula.

    I give up :diablo:

    Have a nice day
  8. Re: Can someone help me with this? Probably a beginner level formula.

    or Power Query :) :) :)
    or even Power Pivot
  9. Re: Can someone help me with this? Probably a beginner level formula.

    all your needs from the first post to now you can do in just PivotTable

    enough to read about: Pivot Table and some more links there.

    or even change your range to Excel Table (Ctrl+T) , add...
  10. Re: Can someone help me with this? Probably a beginner level formula.

    I'll ask again: what about PivotTable?
  11. Re: Can someone help me with this? Probably a beginner level formula.

    did you try a PivotTable?
  12. Replies
    6
    Views
    117

    Re: Match Function Problem

    sure

    What is PowerQuery?
  13. Replies
    6
    Views
    117

    Re: Match Function Problem

    IMHO PowerQuery (Get&Trannsform) would help
  14. Re: Combining 2 lists (for each cell in first list assign all cells in second list)

    you are welcome

    have a nice day
  15. Re: Combining 2 lists (for each cell in first list assign all cells in second list)

    or with PowerQuery aka Get&Transform


    table1table2table1table2

    austinappleaustinapple

    justinbananaaustinbanana

    paulorangeaustinorange
  16. Replies
    20
    Views
    723

    Re: Power Query column alignment

    you can try this


    let
    Source =...
  17. Replies
    20
    Views
    723

    Re: Power Query column alignment

    it takes some time with ca. 5 GB of data (sorry, I didn't check unzipped file size :))
  18. Replies
    20
    Views
    723

    Re: Power Query column alignment

    use Reply not Reply With Quote :)

    https://i.postimg.cc/g2gzkLK5/screenshot-106.png

    your previous source is incorrect because there is no company number, address lin1, etc... , I am trying with...
  19. Replies
    20
    Views
    723

    Re: Power Query column alignment

    this is 868 MB not 5 GB :)

    use header names what you want split/concatenate

    and don't quote whole post, please!
  20. Replies
    20
    Views
    723

    Re: Power Query column alignment

    is that what you want?

    first ten rows...

    ...
  21. Replies
    20
    Views
    723

    Re: Power Query column alignment

    I'll wait to see if the post#4 will work ;)
  22. Replies
    20
    Views
    723

    Re: Power Query column alignment

    you forgot about one thing: DataSource.Error: Could not find a part of the path 'C:\Users\Ben\Desktop\PQ\persons-with-significant-control-snapshot-2019-09-13.csv'.
  23. Re: how to divide and unique names in to one slicer

    I don't know
    Get it or forget it ;)
  24. Re: how to divide and unique names in to one slicer

    use PowerQuery
    split first column by delimiter ", " (comma space) to rows

    then you can:
    create PivotTable from Query Table and insert slicer
    or
    load Query Table to the sheet and insert slicer...
  25. Re: how to divide and unique names in to one slicer

    something like this?

    https://i.postimg.cc/5N35wTCD/slicer.jpg
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4