Microsoft Power Query for Excel enhances self-service business intelligence (BI) for Excel with an intuitive and consistent experience for discovering, combining, and refining data across a wide variety of sources including relational, structured and semi-structured, OData, Web, Hadoop, Azure Marketplace, and more. Power Query also provides you with the ability to search for public data from sources such as Wikipedia.
Questions tagged [powerquery]
5627 questions
1
vote
0 answers
Power Query refresh source table only if not recently refreshed
I have source data in excel workbook that is loaded to Power Query to clean data and result is only connection. (Excel Table => PQ connection ("Main table"))
Then I created two separate tables from this connection ("Main table") that are loaded to…
Michal Palko
- 601
- 1
- 4
- 14
1
vote
1 answer
PowerQuery M - How to refer to a column name that as an apostrophe?
I have a column name such as Titre d'emploi, and when i refer to it as [Titre d'emploi], it gives me an error and i tried multiple things like ["Titre d'emploi"], and i googled for quite a while but nothing really applies.
Would you guys have any…
Swords_Plowshare
- 25
- 3
1
vote
2 answers
power query subtract row below from row above using multiple conditions
I am using Power Query in Excel and I need to calculate the duration on each "Door_side" using the Time column on a daily level for each individual user.
The data comes from a card based access system and is formatted as follows:
Date Time …
Andrea
- 13
- 5
1
vote
1 answer
Add column of previous values from table of tables in Power BI / Power Query
Looking for a followup to Max Zelensky's solution here. Assuming the original example had a [Date] field, I'm trying to go one more level and add a column that shows the prior [Date] value
I've also looked here and here and here.
Per Max, I've…
stevewing
- 13
- 4
1
vote
1 answer
Powerquery - appending the same table to itself using differing columns
So I have a list of properties and a list of the next four servicing dates
e.g:
Property| Last | Next1 | Next2 | Next3 | Next4 |
123 Road| 01-2019 |03-2019| 05-2019| 07-2019| 09-2019|
444 Str | 01-2019 |07-2019| 01-2020| 07-2020| 01-2021| …
Peter Collins
- 37
- 6
1
vote
1 answer
How can I combine (join) ranges from multiple tables?
I don't want an answer based on DAX or Excel formulas.
I have two tables both with Id and cumulative data. Both fields are table independent.
I need to create a new table, table3, which is a join between table1 and the cumulative2 field from table2.…
JoaoSa
- 117
- 1
- 1
- 6
1
vote
1 answer
M Language - Divide by the MAX() of a field
I would like to add a custom column C in my Power BI query (meaning M language, not DAX) so that each value of column B gets divided by the MAX() of column A.
Can't make this work:
Table.AddColumn(#"Changed Type", "Custom", each [B] /…
Julien Allard
- 11
- 2
1
vote
1 answer
Avg. Time Difference (Seconds) Between Events using a Customer ID and Unix Epoch Timestamp
I have a set of data where I would like to track the amount of time in between stages using a Unix Epoch Timestamp and I would like to have it grouped by Customer ID.
The Data looks like the following sample:
Desired Result:
"Avg. Seconds Until…
Sebastian Hubard
- 59
- 7
1
vote
1 answer
How do i use try catch or conditional columns to solve csv issue in power bi
I have a dataset coming into power bi from CSV where certain rows have been pushed to the right because there's a comma in the description. Once i apply a datatype change, this creates errors with the presence of text in a numeric column.
What i…
John Owens
- 61
- 6
1
vote
0 answers
Dax rolling 30 days with SAMEPERIODLASTYEAR
I want to visualize 2 trends in Power BI with rolling revenue for 30 days
First trend - actual day
Second trend - SAMEPERIODLASTYEAR
I have a problem with last day for the Second trend (wrong calculation)
My steps for calculate Second…
Sergey Morya
- 11
- 1
1
vote
1 answer
Excel macro refresh data then format cells
I have a worksheet which contains a Pivot Table, the data is populated from a file output by another system.
Within Power Query I transform the data, specifically I use one of the fields to construct a URL.
"'=HYPERLINK(""" &…
BigK
- 13
- 3
1
vote
1 answer
Find and replace using wildcard in Power BI
I have a column in Power BI that contains difference Operating System such as Windows 7 Professional and Windows 7 Home "etc" I would like to just have them show Windows 7. I thought using the find and replace searching for Windows 7* and replace…
irishombian
- 102
- 4
- 14
1
vote
3 answers
fill time gaps with power query
I have following data
start stop status
+-----------+-----------+-----------+
| 09:01:10 | 09:01:40 | active |
| 09:02:30 | 09:04:50 | active |
| 09:10:01 | 09:11:50 | active |
+-----------+-----------+-----------+
I…
intrixius
- 1,096
- 2
- 11
- 25
1
vote
1 answer
power query custom dynamic date parameters
Is it possible to have a custom start and end date parameter on a report? I would like to have a regular daily report for the week,Tuesday through Friday where the parameter could be today()-1. However , when I run the Monday report I need a start…
Vava
- 13
- 3
1
vote
1 answer
Managing folder refresh in PowerQuery/ Excel
I am uploading several excel files from a folder into PowerQuery and transforming them into an appropriate format.
We have an excel file for every week. So there are 52 files in total.
PowerQuery/ Excel needs for now round about 5min to refresh…
user10732287