6,563 questions
1
vote
1
answer
64
views
Changing Data Query Source File Property
I am attempting to change the Source property of a query in an Excel file via PowerShell. I have found the Connections properties, but am unable to locate the specific property that contains the ...
- 2,088
0
votes
2
answers
48
views
How create a dynamic cumulative sum in power query
I want to create a sum in power query (Measure C below) returns the cumulative sum of Measure A + Measure B and is limited to zero and which resets at the beginning of each Period as shown in the ...
1
vote
1
answer
56
views
Excel Power Query - Dynamically change date in source url from cell value
This is a fairly simple question but I am unable to find any relevant documentation for it.
Having created a power query in Excel how can I alter the date in the url string from user input on the ...
- 115
1
vote
1
answer
36
views
Filter date using bookmarks PowerBI
I would like to change the date daily by clicking on the arrow.
Selected date should be changed daily by clicking on the arrows. Is this even possible ? many thanks in advance.
I need something more ...
- 3,031
0
votes
1
answer
104
views
VBA PowerQuery Directory
I am using VBA to try and hopefully automate my PowerQuery needs.
I've recorded a macro from the import data from PDF in the data tab.
I have then tried creating a user definable source path within ...
- 13
0
votes
2
answers
62
views
Create a calculated column with if statement power query
I have a data as below. I need to create a calculated column in power query. Full name can be consisted of name, last name, middle name and, 2 letters (which should be added in the lastname). Many ...
- 3,031
3
votes
3
answers
224
views
Stack Integer Sequences from a List
Intro
I wrote an answer to Expand records for each month between two dates. A part of my solution was to stack integer sequences from a column of integers. There were only 4 integers in the column, ...
- 56.7k
1
vote
1
answer
39
views
Non-hardcoded AddColumn
I'm trying to write a PowerQuery to enable Users to compare to Data Sources (with an unknown number of fields), determined at runtime by the user filling a table.
Of course if the fields are known I ...
- 75
0
votes
1
answer
41
views
How can I aggregate all columns with a 'number' type in power query
I'm trying to use power query to aggregate some invoicing columns by project number in power query.
I'm currently using a group by function which looks at the project number and then aggregates each ...
0
votes
1
answer
33
views
Using function parameter in field-access-expression
I am trying to convert some hard coded PowerQuery into a function so it can be reused, but am having an issue with the field-access-expression, as it is using the parameter's name rather than value.
...
- 75
0
votes
1
answer
77
views
Replace column value based on another column
#"Added Custom2" = Table.AddColumn(#"Added Custom1", "pm plus",
each pmplus[Qualifies for]{List.PositionOf(pmplus[Combined Criteria],[combined criteria])}),
#"...
- 3,183
1
vote
2
answers
129
views
Power Query – Cancel last N positives based on N negatives
I have a table in Power Query like this:
PO - Purchase Order
SID - Ship ID
QTY - Quantity
PO
SID
QTY
1001
A001
2000
1001
A001
2000
1001
A001
-2000 (This line cancel the previous one)
1002
A002
3000
...
-2
votes
1
answer
52
views
How do I pivot distinct values in Excel (preferably PivotTable fields editor)? [closed]
I have a table layout with different number of text values for each id column. Now, I'd like to pivot them, so that each id gets a single row and each text value is put into a different column of the ...
- 3,262
1
vote
2
answers
110
views
Count consecutive rows in Power BI that have a value. Get start date and max grade from that group
I have a table with the following data:
record_id
visit_date
int_date
month
hb_ae
wbc_ae
anc_ae
plt_ae
ast_ae
alt_ae
arc_hb_ae
sched
10
9/9/2015
7/8/2015
1
2
Sched
10
10/9/2015
7/8/2015
2
2
Sched
10
...
- 397
0
votes
1
answer
123
views
How do I force refresh a PowerQuery with VBA?
I'm trying to automate a workflow with a macro, but I can't seem to get the PowerQuery table to update with VBA.
Sub DepartmentalBudgetsMonthlyUpdate()
Dim wb As Workbook
Dim fName As String
...
