Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Problem replacing/substituting a part of a String variable with a long text string

    Hi
    I have a macro which runs some SQL code to update a table on a server.
    The code and SQL has run fine in the past, but I've hit a road block now, seemingly because SUBSTITUTE doesn't seem to like...
  2. Re: Update userform controls stored in model via VBA

    Many thanks. Just what I needed.
  3. Update userform controls stored in model via VBA

    Hi
    I've not been able to find anything on this via Google, so I'm posted a question on it here in search of some help.
    I'm not very conversant with using VBA on userforms so please bare with me if...
  4. Row level security in Power BI using USERNAME()

    Hi
    I'm having some trouble implementing row level security in a simple Power BI model. I'm using an SS Tabular cube for my data (Visual Studio 2010), and implementing the security in it via a Role....
  5. Re: Excel's MAX & MIN function functionality in DAX

    Thanks again gazpage.

    I think it's the version of Microsoft Visual Studio I'm using (2010!). Hopefully our IT guys will get a more modern version installed sooner than later.
  6. Re: Excel's MAX & MIN function functionality in DAX

    Thanks Gazpage, but MAX & MIN only take a single argument according to the error message I got when I tried this...

    Revenue % Growth YTD:=MIN(999, MAX(-999, DIVIDE([Revenue YTD] - [Revenue YTD...
  7. Excel's MAX & MIN function functionality in DAX

    Hi
    I have a measure to calculate % Growth, but I find I'm getting some large results. I would like to limit the result to be between -999% and +999% in my visuals as these tend to be outliers.
    In...
  8. Re: DAX formula to calculate the full year total for the previous financial year, based on page filter selection

    Thanks Gazpage

    This has done the job - MANY thanks for your help.
    I already had an expansive date table and had tried using my Fiscal Year field but got nowhere - most likely due to my...
  9. DAX formula to calculate the full year total for the previous financial year, based on page filter selection

    I am trying to calculate Total Revenue for the full financial year (ending 30 Jun) preceding the month selected in a filter using my Data Table's Month End field. I've wasted a lot of time on...
  10. Re: VBA SQL ignores a field's values if the first record has the field empty

    Fazza and Mole999

    Many thanks for your time and help with this.

    I think I've solved this now finally - I've used IF(LEN([Details of engagement changes])<>0, [Details of engagement changes],...
  11. Re: VBA SQL ignores a field's values if the first record has the field empty

    Hi Mole99

    The last field [Details of engagement changes] is the problematic one. Generally the field (spreadsheet column) is empty; it will only have a value (as a text comment) as an exception;...
  12. Re: VBA SQL ignores a field's values if the first record has the field empty

    hi mole999

    SQL is as follows:

    [CODE ]
    SELECT
    [Engagement Name]
    ,[Any Eng detail changes]
    ,[Original Eng Id if this has been changed]
    ,[Pricing Model]
  13. Re: VBA SQL ignores a field's values if the first record has the field empty

    Hi RoryA

    I've added IMEX=1 to the connection string, but it didn't help. And after researching what it does (and testing it) I couldn't use it as it converted my numeric columns/fields to text...
  14. Re: VBA SQL ignores a field's values if the first record has the field empty

    I'll have to check RoryA (it's on my work laptop).
    My query is accessing data in ThisWorkbook to process and copy to another one. If it doesn't, I'll add it and retry.

    btw what does IMEX=1...
  15. Re: VBA SQL ignores a field's values if the first record has the field empty

    Hi Mole999

    I did try COALESCE but I kept getting an error when running the SQL (one of those really helpful - not - messages!), so gave up on it.
  16. Re: VBA SQL ignores a field's values if the first record has the field empty

    Hi Fazza

    The column (field) just has text in a couple of rows.
  17. VBA SQL ignores a field's values if the first record has the field empty

    Hi
    I'm running an ADODB SQL query in Excel, pasting the results to another sheet. One of my text fields won't paste any results when the field is empty for the first record. If I have a value in the...
  18. Replies
    7
    Views
    345

    Re: Advise on making UDF more efficient

    Thanks for the tip Stephen
  19. Replies
    7
    Views
    345

    Re: Advise on making UDF more efficient

    I've managed to get this to work! Yah!

    It seems .Find starts at the second cell, then wraps back to the first so if my 1st cell is a match, it gets stuck on the end of my list. Not a big deal at...
  20. Replies
    7
    Views
    345

    Re: Advise on making UDF more efficient

    Thanks Stephen & pvr928 - I'll look into your suggestions.
  21. Replies
    7
    Views
    345

    Advise on making UDF more efficient

    Hi

    I'm helping a colleague solve a time consuming problem by writing them a UDF.
    The UDF shown below takes a string, searches each cell in a range, and builds a comma separated list of all the...
  22. Replies
    4
    Views
    5,694

    Re: External link can't be broken

    I took this macro for a spin. It looks like this error message comes up if there are no Data Validations on the sheet being analysed.

    Ron - I'd suggest changing the error message to reflect this,...
  23. Re: Getting Google Analytics data into Excel via Power Query

    Thanks Comfy & GimmeExcel, I'll try these out and see how I go.
  24. Using VBA to Loop through pivot iitems for a pivot field in a pivot table with a page field filter.

    Hi
    I've Googled my brains out trying to find an answer to this, so I'm giving up and posting a thread here to see if I can get an answer.

    I am using VBA to (try) and traverse a pivot field in a...
  25. Getting Google Analytics data into Excel via Power Query

    Hi.

    I'm trying to pull some Google Analytics (GA) data into Excel using Power Query (PQ), but am not really sure how to go about. I'm pretty new to PQ and GA so, i'd appreciate some advice on how...
Results 1 to 25 of 79
Page 1 of 4 1 2 3 4