Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.06 seconds.

  1. 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 =...
  2. 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
  3. 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
  4. 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
  5. 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...
  6. Re: In Power Query - Decimals getting removed

    User TypeSeverityAttributeValue

    PedestriansKilled0-4 Yrs
    5

    PedestriansKilled5-7 Yrs
    3

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

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

    add calculated field : ='Product A In' -'Product A Out'
  9. Replies
    5
    Views
    148

    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
  10. Replies
    6
    Views
    135

    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
  11. Replies
    6
    Views
    135

    Re: Automatically Alphabetize Names

    with Power Query aka Get&Transform


    FIRSTLASTFIRSTLASTLast, First

    BILLYSMITHRANDYCALVINCALVIN, RANDY

    ZEEWORDWILLHAYESHAYES, WILL

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

    maybe

    From Folder
    Filter by month
    Append (Combine)
  13. 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
  14. 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
  15. 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 :)
  16. Re: Column for subtraction of grand totals in pivot table - power query useful here?

    be sure the name of source table is the same as in the M-code (here: Table1)
    copy code from the post
    open Advanced Editor
    paste code

    here is source table I used


    DateType of movementProduct...
  17. Re: Column for subtraction of grand totals in pivot table - power query useful here?

    so try this


    // Table1
    let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Type = Table.TransformColumnTypes(Source,{{"Date", type date}, {"Type of movement", type text},...
  18. Re: Column for subtraction of grand totals in pivot table - power query useful here?

    is that what you want with PQ ?


    DateAttributeABCUnit CostUnit Cost2ClientSelling PriceProduct A in Stock


    11/10/2019Product A In
    20
    3
    100
  19. Re: Column for subtraction of grand totals in pivot table - power query useful here?

    with table or PowerQuery it is not possible : two the same name of columns, eg: Unit Cost
  20. Re: Power Query - Dynamic Column Headers - By Date

    try with additional table with headers before and headers after, then append, promote , etc...
  21. Re: Resource Management and Planning Software

    maybe MS Project
  22. Re: PowerQuery: Row with same ID, CONCATENATE image column into one row.

    welcome
  23. Re: PowerQuery: Row with same ID, CONCATENATE image column into one row.

    from the ribbon use Split Column with delimiter ", " without quotation marks
  24. Replies
    5
    Views
    6,521

    Re: Query Merge error

    post a link to the shared excel file with your problem
  25. Re: Search in TXT file and return line to Excel

    with Excel 2013 you'll need PowerQuery add-in from MS site (free)
    after install open excel file, show queries, (you'll see error probably), dbl click on query, change path to your txt file in...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4