parameter

  1. M

    Forecasting and what if parameters in Power Bi Desktop

    Hi Everyone, I'm trying to do some predictive forecasting with parameters but I'm coming across an issue when using parameters into the future. What i'm trying to do is forecast the amount of people on a waiting list in the future but this can be altered by using parameters which will remove...
  2. M

    Is it possible to add a parameter in the UserForm_Initialize() function ?

    Hello everyone, So, yeah, the question is in the title. Can I for instance write something like Private Sub UserForm_Initialize(rowCount As Integer) and call it in my macro with myControl.UserForm_Initialize(rowCount) and expect it to work ? Thanks you for reading, Marie
  3. D

    Parameter in ODBC PowerQuery

    Hi Everyone, I've tried to use a parameter from Excel cell to modify an ODBC Query from AS400 Database like this: let BUPKTO = Kunde, Quelle = Odbc.Query("dsn=AS400", "SELECT BBU00.BUFNR, BBU00.BUBHKZ, BBU00.BUPKTO, #(lf)FROM WWC400.WEXFILE.BBU00 BBU00#(lf)WHERE (BBU00.BUFNR='01') AND...
  4. U

    Get & Transform with a parameter from Access query

    Hi there, I was wondering how can I use a parameter in a query using the "Get & Transform" . For simplification purposes, I have a saved query called 'dbQuery': select * from Balances where Balances.CoprID=[Idpara] IdPara is the parameter. "Get & transform" doesn't recognize this query because...
  5. V

    Now that I understand the last parameter in VLOOKUP(), i now have thousands of problems

    Team: The last parameter in VLOOKUP() essentially tells EXCEL whether the range being used for lookup is in ASCII order or not. If not, it has to plow through all the entries in the range, as opposed to doing a binary "search all" (of COBOL fame). So not understanding this for a long time, most...
  6. R

    Declaring an array

    Hi All I have a workbook with a number of sheets and a second workbook containing data that is to be entered into the first workbook base on a selection parameter. This parameter I have called BC and is contained in block with differing numbers of parameters in Range ("A2") to Range ("A" & 2...
  7. A

    Prevent Named Range Reference From Changing

    I have two named ranges I use as sources for their respective combobox lists. Since the ranges are dynamic, I use a formula as reference ... =OFFSET(ROSTER!$A$2,0,0,COUNTA(ROSTER!$E:$E)-2,1) WHat is happening though, from within my VBA application, the worksheet will many times get altered...
  8. J

    build source file path through multiple parameters?

    Hi all, I'm trying to learn how i might be able to use parameters to build my source file paths for a variety of queries using Power Query... I think i'm most of the way there, but getting tripped up on the last one, which is a query type parameter that i want to generate a list of values...
  9. seba64

    What form call the function?

    Think that it is possible for a function to know the name of the form that called it.? think that function can be in at unknown project of a unknown programmer. with an object like parameter i can found the parent, but in this function i haven't any object like parameter. I hope you...
  10. C

    Parameter Query Want to Enter Current Data for TeraData pull

    This is the current Power Query code: With the data coming from another Power Query table (tblDateCurrent) with only one entry. let Source = Teradata.Database("cdwp", [HierarchicalNavigation=true, Query="SELECT #(lf) DIV_DESC,#(lf) DEPT_DESC,#(lf) SUB_DEPT_DESC,#(lf)...
  11. R

    Complicated issue in Excel

    Hello guys. I have an issue. I have to sort the data, but optimised in order to be less than 100.000 but the sum nearest possible. Virtually I need a way in order to have some data, I want that data selected by the excel (preference for the parameter of the data, but the main preference has to...
  12. A

    How to use Solveradd for step parameter?

    I want to VBA Solver search parameter array like as 5, 8, 11, 14, 17...60 step 3, I use SolverAdd code as follow but not work?Why [W4] as parameter start 5 Range("step") = 3 SolverAdd CellRef:=[W4], Relation:=2, FormulaText:=2+Range("step")*Int([W4]/Range("step"))
  13. dab1477

    neophyte needs query help - omit paramerter value request window

    Thanks in advance. I am an intermediate user of Access and have the following issue: How do I omit the parameter windows show for SUMofPLANNEDSCREENS SUMofActualScreens SUMofACTUALMnhrs as part of Query A, that pull the data from Query B? I have a query that pulls data from a Query B. Query...
  14. J

    Script to change query parameters

    In my dBase, I have three queries that have a parameter that is coded Like"*TUC*" The dBase is designed to be used by various locations with different location coded. Is there a way to change the query parameter in these three queries via a script?
  15. F

    Opening a protected book from cmd, passing pwd as a parameter.

    Hello! I need to open a protected book reading a BAT file, in a silent way, without messages or alerts. Perhaps including the pwd as a parameter in the command line but I couldn't find how to do it. Thanks in advance.
  16. M

    Nested INDEX Functions to Select INDEX ISBLANK-Wrapped Reference Range Using Area_Num Parameter?

    I am trying to use the INDEX function to select a reference range created by another INDEX function selected by the "Area_Num" parameter where that other INDEX function refers to an ISBLANK-wrapped reference range. For reference, I have the following Excel formula in Excel 2016 on Windows 10...
  17. A

    Append Query Error --- Enter Parameter Value when None exist

    Hi all, I have a large database and I am attempting to build a separate archive database. For now, while testing and building, I am just trying to start by writing an append query to a new table in my database. This table, tblArchiveItems, was created using the structure only of tblItems. I...
  18. J

    Data Source Dynamic Parameter

    Fairly new to Power Query or the get data function. I am trying to set up a query from an Odbc data source with a dynamic parameter for the Schema. The server will always remain the same however the Schema (not entirely sure what that is?) is what will change then the table name will remain the...
  19. S

    ExportAsFixedFormat on Mac

    Hi guys, Got some problems with ExportAsFixedFormat in VBA on Mac, more precisely with the parameter "FileName" which is defining our filepath. I want to decide where I will save file and which name of file will be. Usually I don't get error but when I'm trying to swap "FilePathName" in...
  20. M

    is there a way to combine a vlookup and hlookup - i.e., search with two terms

    I have a table of values where column A starting in row 2 is parameter one which increases as the rows go down. Columns B-F in row 1 are increasing values of parameter two. Filling in the rest of the table are the results obtained with an input from parameter one and parameter two. How can I...

Some videos you may like

This Week's Hot Topics

Top