python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - m

Power BI - M query to join records matching range

I have an import query (table a) and an imported Excel file (table b) with records I am trying to match it up with. I am looking for a method to replicate this type of SQL in M: SELECT a.loc_id, a.oth...
test-img

Aaron H.

powerbi

m

Votes: 0

Answers: 1

Latest Answer

This is not very specific "After 34A01 could be any string..." in trying to figure out how your series progresses. But maybe you can just test for how a value "sorts" using the nat...
test-img

Ron Rosenfeld

Combine PDF where target information in different position

I have several PDF file need to combine and get one target information from each file. Target information is a date. I can only locate the target information in a specific line (now each file has one ...
test-img

Song_Rui123

powerbi

powerquery

m

Votes: 0

Answers: 1

Latest Answer

In powerquery, if you had a whole table already populated as in your example Then to get target name (next to last non-null column) , add column, custom column with formula = List.LastN(List.RemoveN...
test-img

horseyride

Cumulative Sum if previous row in another column is the same

I'm trying to do something that is simple in excel but I need it to be added in my query. I am trying to create a cumulative sum in a new column of time values in one column if a name column equals a...
test-img

UBP

dax

powerquery

m

Votes: 0

Answers: 2

Latest Answer

In powerquery, try below and replace Table2 with the name of your source data table let xFunction = (xTable as table) as table => let #"Added Index" = Table.AddIndexColumn(xTable, &q...
test-img

horseyride

set Power Query display folder for a query column in M?

I have a number of very wide datasets in Power Query - hundreds of columns each (don't ask). I am trying to determine if (how) to assign columns to display folders programatically. I have access to ...
test-img

Jim Barnes

powerbi

powerquery

m

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs