Questions tagged [m]
The M Modelling Language was a component of Microsoft's "Oslo" project, later known as SQL Server Modeling CTP. The project was canceled in late 2010 but the language was updated and incorporated into Power Query, Power BI, and Excel.
1,353
questions
0
votes
1
answer
19
views
Conditionally duplicate records and modify one column using PowerQuery/M in Power BI
I'm using PowerQuery/M (well ,trying, this is my first time having to go beyond the basics) in Power BI. I have a json file representing a tree like structure, which I am trying to flatten out.
The ...
- 1
2
votes
3
answers
91
views
Extract the start and end date of a sick leave in power query (gaps and islands)
I would like to have a max and min date of the different types of absence for every employee for project. I would like to have it in Power BI but I don't know how to do it.
There are 3 columns that ...
- 309
3
votes
1
answer
57
views
Ignoring error in Table.ExpandTableColumn or auto-replace with null
I am loading 100s of XML files from a folder and Power Query has created a function from the first file I had loaded. The problem is not all the XML files have a similar structure. Some have nodes ...
0
votes
0
answers
20
views
problem with import text in pdf by power query (right to left language)
if i convert ".pdf" to text & use get data from ".txt" or ".csv" file & set file origin on "1256:Arabic (windows)", then i have a correct text in PQ.
...
0
votes
0
answers
36
views
Power Query Pagination when the cursor reference for the next page is given as part of the initial JSON Response
I know this has been answered several times with a loop and a variable to hold page size and count, but the API I'm trying to use doesn't have those parameters.
In my API Call:
https://someserver....
1
vote
1
answer
25
views
Power Query - Add column with path for each file
I have two queries (working) hat do exactly what I want:
they scan a folder for DBF files with a particular name
convert each one into a table
combine the tables into one long table
I want to add a ...
- 437
0
votes
1
answer
45
views
Use Power Query to consolidate rows (like Pivot Table, but maybe something else)
(Very simplified) I have data like this that I get after a complex series of steps in Power Query.
Previously, I used a Macro to create a Pivot table like so:
But I was hoping to get away from that. ...
- 39
1
vote
2
answers
43
views
Extract JSON Array to same Row using Excel Power Query
I have the following JSON
{
"Data": {
"totalExecutionTime": "00:00:00.5544916",
"totalCount": "33414",
"Items": [...
- 3,547
0
votes
3
answers
60
views
Create a column that counts all "Y" in all other columns for each row in Power BI
I am working in Power BI and have dataset with columns containing "Y", "N", or "NA". There are over 100 columns so I am trying not to create an if statement for every ...
- 59
1
vote
1
answer
30
views
Partial Power Query transposition so that captions remain
Novice power query user here. I would greatly appreciate if someone could help me with the following problem. I'm tasked with modifying an excel template that is roughly of that format:
City
Borough
...
- 15
1
vote
2
answers
42
views
Identifying the max in a group using PowerQuery
I have a table:
trip_id
stop_sequence
Y1
1
Y1
2
Y1
3
Y1
4
Y1
5
Y2
1
Y2
2
Y2
3
Y2
4
I want to add a custom column that has a value of TRUE for the record which has the highest value of ...
- 988
1
vote
1
answer
55
views
Microsoft Graph API - Pagination to get more than 500 members
I'm trying to extract the users of an azure group, I use first a function ''GetToken'' to get select the group from Azure and the token, then I use this function to get the users:
let
Source = (...
- 11
0
votes
1
answer
41
views
Calculating average for each category and for multiple columns
I have a table there rows represent time period. Columns represent different locations "kiosks".
And values represent sales in each kiosk on different times.
Data example:
Date and time
...
- 7
2
votes
2
answers
35
views
How to do aggregations while preserving the same number of rows?
My input table is the two orange columns and I'm trying to create the three blue ones :
The column ND_ID is the index of each group of ids
The column CNT_ID is the length of each group of ids
The ...
- 1,095
2
votes
1
answer
62
views
Does unchecking enable load have impact on refresh?
I'm looking at an example where the enable load is unchecked. This automatically grays out the include in report refresh option.
So it neither loads into the model nor does it refresh this table.
...
- 9,213