• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. G

    Power BI: Dax: New column: If criteria occurs more than once return "1" with the last occurence

    I already have a solution: Column 2 = VAR x = CALCULATE( MAX(Sheet1[timestamp]), FILTER( ALL(Sheet1), Sheet1[userId] = EARLIER(Sheet1[userId]) && Sheet1[status] = "EFP" ) ) VAR y = CALCULATE( MIN(Sheet1[timestamp]), FILTER( ALL(Sheet1)...
  2. G

    Power BI: Dax: New column: If criteria occurs more than once return "1" with the last occurence

    Hi all, I have this table: I want to create a column "excludedUser" in which to return "1" when the column "status" says "ExcludedFromProject" But sometimes a user is accidentally excluded, and later included ("IncludedInProject") again. In the example above (rows in yellow) the first...
  3. G

    Keep columns , reorder them and delete the other columns

    @shrivallabha Thank you! Works like a charm!
  4. G

    Keep columns , reorder them and delete the other columns

    Hi, I have a worksheet with these about 20 columns (somtimes more an sometimes less) which have been imported in Excel. These columns have to remain in the worksheet: First Name Middle Name Last Name Title Company CompanyProfile CompanyWebsite Email Phone Problem is that...
  5. G

    Power BI: Query Editor: Copy/duplicate query

    Hi Chihiro, thank you for your tips, i have something to sink my teeth into now.
  6. G

    Power BI: Query Editor: Copy/duplicate query

    Hi Chihiro, thank you. I will try to explain. I have made an embedded Power BI report for a customers site. We used to pay Microsoft(Power BI Premium) 600 euro every month for running this report. It has a refresh schedule (it is refresh every hour) and the customer can manually refresh. But...
  7. G

    Power BI: Query Editor: Copy/duplicate query

    Hi Chihiro, thank you. I tested that already. When I refresh the data it runs the original query and the reference query, and that what I don't want. I want it to run only once. govi
  8. G

    Power BI: Query Editor: Copy/duplicate query

    Hi, Is it possible in the query editor to make a copy/duplicate of a query? This "mother" query must feed the copy/duplicate with new data when it is refreshed. But it is important that the copy/duplicate doesn't refresh (connect to the datasource) itself. Thank you! govi
  9. G

    Problem with wildcards

    Hi Deepak, thanks for your reply. Solved it already with a colleague
  10. G

    Problem with wildcards

    Hi, I us this code to mail clients with a maximum of 5 attachments. The paths to the the attachments are in range R1:V1 I need to use a wildcard because the attached files can be any extension. The paths I use now are: G:\AHC\01. AHB Primair Proces\05. Teammappen\03. Team CCH PP\1b...
  11. G

    Looping

    Hi p45cal Thanks for your solution. I for one for myself already. Govi
  12. G

    Looping

    Maybe it is convenient that I put part of the code in the post: --more code above this-- Range("n2").AutoFill Destination:=Range("n2:n" & Range("A" & Rows.Count).End(xlUp).Row) Range("o2").Select Selection.FormulaR1C1 = "Nee" Range("o2").AutoFill Destination:=Range("o2:o" &...
  13. G

    Looping

    Hi I have a macro which in the end mails a record(sends it to Outlook) The macro copies a record(from sheet import) to another sheet(mail), the copied record is removed from sheet import After that the copied record(which is now on sheet mail) is send to Outlook. The loop has to start with...
  14. G

    Hyperlink question

    Thanks! That does the trick!
  15. G

    Hyperlink question

    Thanks Hui, Is it possible to remove the Hyperlink function but still keep all functionality. I mean the correct name is displayed en the hyperlink is still functioning? govi
  16. G

    Hyperlink question

    Hi there, I have a hyperlink question: Cell A1 is empty In cell B1 is a name eg: CNN In cell C1 is a webadress eg: http://cnn.com In cell A1 I want the name(B1) containing the webadress from C1 I know I can do it with the Hyperlink function, but I need a macro because I don't want a...
  17. G

    Run macro every x minutes

    Hi Marc L and SirJB7, I figured it out, thanks for your tips. govi
  18. G

    Run macro every x minutes

    Hi there, I have a macro with a bunch of code. I want it to run every 5 minutes. Any suggestions? Thanks! govi
  19. G

    VBA code not working anymore

    Yep!, path was wrong....thank you!
  20. G

    VBA code not working anymore

    Hi, My code for exporting a .gif of a range worked fine but lately I get an error at this line: chtObj.Chart.Export sFile Can anyone help solving my problem? Thanks, govi The whole code: Sub ExportGrafiekWorkoutdata() Sheets("grafieken_workoutdata").Select Dim sfilename As...
  21. G

    Code doesn't work anymore

    Hi Indian, your code doesn't work either Hi Hui, it is code I got from you about a year ago on this forum. And it worked fine until a few week ago. I can't step to the subroutine using F8 because I need to put put FINISHED in a cell first I just have removed the code, then put FINISHED in the...
  22. G

    Code doesn't work anymore

    First of all a happy new year to you all. I have a macro which always worked perfectly. Now part of it doesn't doe it's job properly anymore: Sub Worksheet_Change(ByVal Target As Range) Application.ScreenUpdating = False If Target.Cells.Count > 1 Then Exit Sub If Target.Column <&#62...
  23. G

    Macro to change formulas

    Thank Luke M! Your assumptions were right!
  24. G

    Macro to change formulas

    Hi I have a worksheet(02-01-2012) with formulas pointing to another worksheet: ='01-01-2012'!N10 I have made a macro which creates a copy of sheet 02-01-2012 and renames it to 03-01-2012. How can I change the formulas in sheet 03-01-2012 so that they point to 02-01-2012? I want to use...
  25. G

    First: find correct ID, than: match transaction codes

    Correction on post above. I CAN copy the tables to the same workbook. Does that make it any easier?
Top