Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.07 seconds.

  1. Re: Replacing/Adding text in a different column

    it looks like Merge option but without representative example data of source and expected result it's hard to say something more
  2. Replies
    8
    Views
    130

    Re: Breaking split at not 0

    It's info from MS site, I won't argue with MS :)

    Link: Base()
  3. Replies
    8
    Views
    130

    Re: Breaking split at not 0

    BASE function

    Excel for Office 365 Excel for Office 365 for Mac Excel for the web Excel 2019 Excel 2016 Excel 2019 for Mac Excel 2013 Excel 2016 for Mac Excel for Mac 2011

    Post #1 does not...
  4. Replies
    8
    Views
    130

    Re: Breaking split at not 0

    or A2: =BASE(A1+4,10,8) where A1: 00000001
  5. Re: Power Query - Dynamic Column Headers - By Date

    I am glad you solved your problem

    Have a nice day
  6. Re: Power Query - Dynamic Column Headers - By Date

    Post representative example of source data and expected result
  7. Replies
    13
    Views
    392

    Re: In Power Query - Decimals getting removed

    ok, no problem
  8. Re: Match multiple values from one column with single value from other column

    You are welcome

    Have a nice day :)
  9. Replies
    13
    Views
    392

    Re: In Power Query - Decimals getting removed

    I can post steps what you should do, nothing more nothing less. I you wish of course :)
  10. Replies
    13
    Views
    392

    Re: In Power Query - Decimals getting removed

    check this file

    PQ unpivot to data model
  11. Re: Match multiple values from one column with single value from other column

    sure,


    // Table1
    let
    GB = Table.FromList({1..4}, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Type =...
  12. Re: Match multiple values from one column with single value from other column

    you mean like this?


    LOCGRADEBLSMTM3GradeLoc

    1P
    3
    17870.5263
    2428.082256
    2841.1915
  13. Re: Match multiple values from one column with single value from other column

    with Power Query aka Get&Transform


    LOCGRADEBLSMTM3GRADELoc

    1P
    3
    17870.5263
    2428.082256
    2841.1915
  14. Replies
    13
    Views
    392

    Re: In Power Query - Decimals getting removed

    see post #5

    btw. why you loading Query Table into Data Model?
    If you want create Pivot Table you don't need a Data Model, enough Unpivoted Query Table and standard Insert - Pivot Table
  15. Replies
    13
    Views
    392

    Re: In Power Query - Decimals getting removed

    add your table directly to Data Model from Power Query without loading any Query Table into the sheet

    https://i.postimg.cc/05fmtY1d/screenshot-111.png

    Don't quote whole post, it doesn't make...
  16. Replies
    13
    Views
    392

    Re: In Power Query - Decimals getting removed

    User TypeSeverityAttributeValue

    PedestriansKilled0-4 Yrs
    5

    PedestriansKilled5-7 Yrs
    3

    PedestriansKilled8-11 Yrs
    6
  17. Re: Add new column to pivot table which calculates based on grand total

    but positive result isn't truth
  18. Re: Add new column to pivot table which calculates based on grand total

    add calculated field : ='Product A In' -'Product A Out'
  19. Replies
    5
    Views
    156

    Re: VLOOKUP and extract #N/A rows

    Power Query is not necessary to do that, enough normal table and from the text filter: equals : #N/A
  20. Replies
    6
    Views
    144

    Re: Automatically Alphabetize Names

    it depends on the version of Excel you use, if 2010/2013 add-in is required, if higher - PowerQuery is build-in
  21. Replies
    6
    Views
    144

    Re: Automatically Alphabetize Names

    with Power Query aka Get&Transform


    FIRSTLASTFIRSTLASTLast, First

    BILLYSMITHRANDYCALVINCALVIN, RANDY

    ZEEWORDWILLHAYESHAYES, WILL

    WILLHAYESPAULMORRISMORRIS, PAUL
  22. Re: Check to see if sheet exists before Power Query consolidation

    maybe

    From Folder
    Filter by month
    Append (Combine)
  23. Re: Column for subtraction of grand totals in pivot table - power query useful here?

    you are welcome

    if you want learn much more see post #7 and last link

    have a nice day
  24. Re: Column for subtraction of grand totals in pivot table - power query useful here?

    in PQ editor you've steps on the right side, click every single step to see how it was done

    https://i.postimg.cc/PJzT3c1h/screenshot-110.png
  25. Re: Column for subtraction of grand totals in pivot table - power query useful here?

    You are welcome

    I used PQ ribbon for everything, nothing manual :)
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4