Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.07 seconds.

  1. Replies
    18
    Views
    282

    Re: Need help with Get External Data (long shot question!)

    or much simpler version with automated Year and Refresh on Open file


    let
    Source =...
  2. Replies
    18
    Views
    282

    Re: Need help with Get External Data (long shot question!)

    and this is a whole used M-code and formula

    A2:
    =YEAR(TODAY())


    let Year = (YR) =>
    let
    Source =...
  3. Replies
    18
    Views
    282

    Re: Need help with Get External Data (long shot question!)

    did you re-download the file?

    you need delete previous downloaded file and download again
    try again ;)
  4. Replies
    18
    Views
    282

    Re: Need help with Get External Data (long shot question!)

    In case with formula =YEAR(TODAY()) edit Query Year and change name of the Query Table to tblYear

    https://i.postimg.cc/3w078zFb/screenshot-125.png or re-download the file from post #11

    be aware...
  5. Replies
    18
    Views
    282

    Re: Need help with Get External Data (long shot question!)

    in A2 remove Data Validation list then insert: =YEAR(TODAY()) (you can use NOW() instead of TODAY() if you want)
    in Data tab - Connection - select connection [Query - Year] - Connection Properties...
  6. Replies
    3
    Views
    281

    Re: Power Query - Calendar Table

    look at https://www.mrexcel.com/forum/power-bi/1087524-power-query-get-fiscal-year-fiscal-month.html#post5226438 or https://exceleratorbi.com.au/build-reusable-calendar-table-power-query/
  7. Replies
    18
    Views
    282

    Re: Need help with Get External Data (long shot question!)

    ok, you've PowerQuery built-in

    so try this:

    Example

    don't open it in browser just download and open in Excel :)
  8. Re: Return a Suppler name from a text string

    is your spacebar damaged?
  9. Replies
    25
    Views
    484

    Re: Find all matches and consolidate them

    Pivot Table:
    just re-create PT, add filter CodC, DCscription to existing Qty and it will work

    Power Query:
    all steps you can see: Data tab, Show Queries, in Workbook Queries you will see four...
  10. Replies
    18
    Views
    282

    Re: Need help with Get External Data (long shot question!)

    What is your Excel version?
  11. Replies
    25
    Views
    484

    Re: Find all matches and consolidate them

    again, what is your Excel version?

    try zip file
    no right click, just click
  12. Replies
    25
    Views
    484

    Re: Find all matches and consolidate them

    I added solution with PivotTables
  13. Replies
    25
    Views
    484

    Re: Find all matches and consolidate them

    what is your excel version?

    you need to download/save the file on your HD or Desktop, not open in browser!
    then open in Excel
  14. Replies
    25
    Views
    484

    Re: Find all matches and consolidate them

    wrong tables above, example file is correct and tables should be like here


    DCscriptionFirst CharactersQty4DCscriptionFirst CharactersQty2

    Aerial - 1/4" Preform Straight SpliceM
    4F150/1500...
  15. Replies
    25
    Views
    484

    Re: Find all matches and consolidate them

    here is your example with Power Query

    Example file


    DCscriptionFirst CharactersQty4DCscriptionFirst CharactersQty2

    Aerial - 1/4" Preform Straight SpliceM
    2F150/1500 PickupE
    2
  16. Replies
    25
    Views
    484

    Re: Find all matches and consolidate them

    with total count

    is this acceptable for you?


    First CharactersCountDCscription

    M
    4Aerial - 1/4" Preform Straight Splice
  17. Replies
    25
    Views
    484

    Re: Find all matches and consolidate them

    with you example (post#1) via Power Query


    ABCCSumB

    M1
    2TwigsTwigs
    5

    M1
  18. Replies
    3
    Views
    111

    Re: Auto Refresh Power BI

    You are welcome

    Happy PQuerying :)
  19. Replies
    25
    Views
    484

    Re: Find all matches and consolidate them

    you can refresh PT automatically after any change in source table via vba (grrrrr!)
    try:

    Private Sub Worksheet_Change(ByVal Target As Range)
    ...
  20. Replies
    3
    Views
    111

    Re: Auto Refresh Power BI

    maybe it will help:
    Auto(?) Refresh PBI
  21. Re: in PQ can we merge multi sheets in Multi Workbook at same time

    who said that???

    see

    https://i.postimg.cc/GmPStFpk/screenshot-124.png

    I suggest to read:


    What is PowerQuery
  22. Re: in PQ can we merge multi sheets in Multi Workbook at same time

    this is 6 steps



    From Folder then merge tables in the same query = one query = one step

    or I don't understand your logic, sorry , maybe someone else

    have a nice day
  23. Re: in PQ can we merge multi sheets in Multi Workbook at same time

    you mean "one click and go?"

    in post#2 I said From Folder then merge tables - this is one query

    or explain what one step means to you
  24. Re: in PQ can we merge multi sheets in Multi Workbook at same time

    maybe use From Folder option then merge sheets
  25. Replies
    5
    Views
    125

    Re: how to simplify nested if

    look at CHOOSE() function
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4