Questions tagged [powerquery-m]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
72 views

Combine and Propagate "Vectors" in Power Query M

Background In an earlier post, I prototyped an M equivalent of tidyselect in R: in particular, its general syntax and selection helpers. In this post, I prototype ...
Greg's user avatar
  • 399
1 vote
0 answers
99 views

"Tidy Selection" in Power Query M

Update I have posted a sequel (here) with my prototype for the "missing piece": the combination and propagation of variable names, especially within nested ...
Greg's user avatar
  • 399
2 votes
0 answers
64 views

Framework for Cumulative Calculations in PowerQuery

Background I found myself needing some M equivalent of cumsum() from R. After some frustrating research, I discovered that there is little support for cumulative ...
Greg's user avatar
  • 399
1 vote
0 answers
66 views

Subset and Sample Lists and Tables in PowerQuery

Background Consider this trivial dataset: x y 1 1001 A 2 1002 B 3 1003 C 4 1004 D 5 1005 E For an R programmer, it is easy to subset this arbitrarily by position: ...
Greg's user avatar
  • 399
0 votes
0 answers
48 views

Recursively Tabulate All Folder Contents in Power Query

Background As discussed here on Stack Overflow, I am comparing a local and a OneDrive version of the same superfolder, in order to identify discrepancies in the sync. As such, I must compare all ...
Greg's user avatar
  • 399
1 vote
0 answers
100 views

A Type.FromText function in M for PowerQuery using Expression.Evaluate

The Solution I recently came across this solution here, for a Type.FromText() function in M for Power Query*. This solution allows a user to extract the actual <...
Greg's user avatar
  • 399
2 votes
0 answers
377 views

Generic function for interpolating missing values in power query

I have written a (relatively) generic function for interpolating values in power query (also useful for power bi and m code). I am looking for any improvements or input, but especially: speed handle ...
S. Melted's user avatar
  • 221