Search:

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

Search: Search took 0.00 seconds.

  1. Re: Power Query Transform & Table Formulas not propagating to new records brought in

    I confirmed the table should propogate formulas per the above mention.

    So one thing I noticed today when updating the query, when i click on the table created by the query it doesn't extend to the...
  2. Re: Power Query Transform & Table Formulas not propagating to new records brought in

    Mike,
    Below is what I pulled out of the advanced editor. (I removed the extensive items I removed and changed to date to show only the ones from above)
    Its about 12k Records, and it only seems to...
  3. Power Query Transform & Table Formulas not propagating to new records brought in

    Hello,
    I Have a query that combines 6 connection only data sets, removes a bunch of columns, moves them around, changes all "Dates" to date code, etc. Nothing out of the ordinary.

    In the...
  4. Re: Countifs and indirect references question

    Bump for help!
  5. Countifs and indirect references question

    First: Thank you for reading.

    My issue, I have a formula on a waterfall type report that uses a lot of countif functions to determine if a site is forecasted/actualized, and counts it if it is. I...
  6. Power Query & Bringing in Values based on condition

    Thank you for your time in reading this<
    I've done my share of searching, but I think I don't know how to ask this question.

    I have a workbook with multiple connection queries, but I don't want...
  7. Pivot table question> Maybe easy? but I need help - Splitting up milestone into month groups

    I have rows that consist of projects, and columns that consist of all the milestones for said projects, each with a date
    lets say 15 columns,
    I need a pivot table that shows all those milestones...
  8. VBA Help with changing tracker on different excel sheet

    Good Morning,
    I have an excel sheet I'm building that does budgeting for specific types of projects. I have most of the VBA worked out for that. The part I'm having issues with is updating an...
Results 1 to 8 of 8