Skip to main content
Stack Overflow
  1. About
  3. For Teams
Filter by
Sorted by
Tagged with
4 votes
2 answers
116 views

I'd like to concatenate values from all columns of a table and store the concatenated result in a new column. Yet, as far as I can see, I can only run a single expression in an `each` function body. ...
AxD's user avatar
  • 3,324
0 votes
1 answer
80 views

I am trying to combine a large amount of files that are essentially text files with an odd file extension (.pri). Each file is named by date (03312022.pri), but the date of the file is not included in ...
ShankRides's user avatar
1 vote
1 answer
117 views

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 ...
0 votes
2 answers
87 views

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 votes
3 answers
248 views

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, ...
0 votes
0 answers
56 views

I'm using SMAppService to register a LaunchAgent for my macOS application. The agent is part of my main application bundle. The main app's name is X, and its Info.plist has CFBundleDisplayName set to ...
1 vote
2 answers
185 views

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
60 views

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 ...
1 vote
2 answers
150 views

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 ...
3 votes
2 answers
154 views

I have these two tables: +-------------------+ +-------------------+ | TAB1 | | TAB2 | +---------+---------+ +---------+---------+ | PRODUCT | ACCOUNT | | GR | ...
Jacek's user avatar
  • 31
2 votes
1 answer
66 views

I have a situation where I have a Power Query that connects to a database, and I only want to display certain columns in my spreadsheet. I know this can easily be done with Remove Columns. However, ...
Boom's user avatar
  • 514
3 votes
1 answer
46 views

I added a custom column to say: If the Status column equals Active or Pending bring the date from the Office Date column. For any other values in the Status column, bring the date from the Incoming ...
0 votes
1 answer
44 views

I have ceated a sales dashboard with a flag filter for Last 1 Week, Last 4 Weeks, Last 12 Weeks, Last 26 Weeks and Last 52 Weeks sales in my dates table.The data is aggregated weekly and I have date ...
1 vote
2 answers
205 views

A column in my power query has the names of various airlines in one string. An example is: American AirlinesBritishAirwaysFinnairAlphaSky I need to split this column into the separate airlines, but ...
1 vote
1 answer
99 views

I have an API I want to call that uses pagination. I followed this blog: How to do pagination in Power Query, and got it working on Power BI desktop to get all the data with multiple calls and paging. ...

15 30 50 per page
1
2 3 4 5
...
95

AltStyle によって変換されたページ (->オリジナル) /