parameter as variable

I am trying to create a Power Query with a parameter that what would perform the Table.Group function based on the parameter value. For example, if the parameter value Group by Region= "Yes", then sum up the sales and profits for each region. If the parameter value does not equal "Group by...

I am trying to run a query in excel where I can use a column from a different sheet to pull the data I need. In excel I run a query and pull the follow fields (plus some): <tbody> Account Number Effective Date System Next Pmt Date Payment Amt 123456 2/17/2017 IVR 3/13/2017 $200.43 254684...

<colgroup><col><col span="3"></colgroup><tbody></tbody> I have a Table 1 which contained the sub account number and the related amount. The sub account numbers are then grouped to a master account number which is presented in Table 2. Table 2 is like a directory to guide what sub account numbers...

I have a spreadsheet that pulls data from a SQL database. Then I have a button that lets the user FTP the sheet to send the manipulated spreadsheet to a customer. What I need to do is take one column of the spreadsheet, take the unique values in it and either use it as where clause in a sql...

I have a funtion like: =IF(LEFT(A3,1)="A",1000,IF(LEFT(A3,1)="B",2000,IF(LEFT(A3,1)="C",3000,4000))) In this formula, LEFT(A3,1) appear three times and excel will run LEFT funtion three times. Can use like this? =IF(LEFT(A3,1) AS X="A",1000, IF(X)="B",2000,IF(X)="C",3000,4000))) Thanks. I...