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...

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...

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...

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...

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...

I have created an Excel dashboard that uses VBA code to import data files in csv format. The data includes dates, and since I and other users are European I had to add the "Local:=True" parameter to my Workbooks.Open command to avoid certain European format dates being converted into US date...

Greetings! I am plotting a radar chart with 6 nodes (based on each of the parameter values). The Excel plot rightly plots the dimensions on 6 different nodes, but also creates a dummy node axis, without any parameter. Is there any advise on how to remove this 7th node (with the 6 parameters to...

Hello, I'm trying to create a query using the Microsoft Query Wizard that will query a table in another Excel Workbook. The command text that is generated by the Query Wizard is below. Works fine until I add a Where parameter (see below). Command Text ("Tab" is the name of the worksheet...

Hello, I have a workbook that has many rows of data. I wrote a macro that filters on column B, then the macro inserts a formula into column C to copy over the first 4 characters. I am using this line of code to bring the characters over filling in to the last row. <code> 'Below Inserts a...

Is this possible? I'd like to add a button to our custom toolbar on a standard report that opens a .pbit file and enters the file path of the existing file as a parameter. I am fine to create the toolbar icon, extract the current filepath etc, but I don't know if it is possible to open and...

Hi! I would like to find past and nearest date with parameter "X" for a given date. Sorry for my English :).

I am using a sheet where a user can enter (pick from drop down list) the name of the sheet, then data is gathered from that sheet using indirect formulas. This all works great, but there is one type of sheet I don't wan't to allow. The user enters the sheet name in cell D6. I have a built in...

I have a SQL query using an ODBC DN connection that works. However when I change the statement:HAVING (InvMaster.StockCode = 'SJ8248009600') to use a parameter:HAVING (InvMaster.StockCode = ?) Excel prompts me to link the parameter which is done successfully. But upon refresh gives the...

Hi All, I have a simple problem that I can't solve. I have a Checkbox on a form and want a Query to pick up if it is selected. So I have used the line: tester: IIf([Forms]![Months]![JanChk]=-1,"Y","N") When the Query is run it asks for a Parameter Value. If I click OK I get 'N'. It seems so...

Hi, I am new to the Excel query scene but I already love it. However i am having a problem that I know is very easily solved. I am generating a query from a table. I want this table to be filtered on Column2 based on a value in a cell in the sheet. I tried filtering on any value and then...

Hi been using ODBC SQL queries for 12months plus, not a huge user of VBA. I am wondering when using a parameter query can I create a string for multiple criteria currently I can use a single criteria customer = ? [and link it to a parameter in cell a1] but anyone know a way I can do...

Hi, How can I add if function to below code? I want if parameter value (yonetici=All ) is equal "ALL" don't filter or filter all esle filtering by parameter value as below. Is it possibe in Power Query? Filter by paramert values with if conditions let Source =...

I have table like below. Is it possible to write something up to show on a separate sheet or on a popup the parameters( age etc) and give me an option to choose wether I want an average or std Deviation of the data set for each parameter. Example table: <tbody> Parameter SET1 SET2 SET3 Age...

I have a field that keeps on popping up when I run a report that behaves like a parameter query (where you have enter in the text box the value you want displayed). However, I don't have a parameter query running in my query in that field. It looks like phanthom parameter query. I redid the...

Hello, I was wondering if someone could help with an issue I'm having with my parameter in Power Query. I've created a table in excel I want to be the parameter value, which I've referenced in the filter in Power Query. It works fine when I select one value, but is there a way to select...