Skip to main content

Questions tagged [powerquery-m]

The tag has no usage guidance.

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

Calendar Table in Power BI

I've been reusing calendar tables in various formats for a few years now. I'd like to know best practices and if there are ways to improve them. Any suggestions for style, code, etc. are all welcome. ...
aduguid's user avatar
  • 490
0 votes
0 answers
76 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
  • 403
1 vote
0 answers
109 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
  • 403
2 votes
0 answers
65 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
  • 403
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
  • 403
0 votes
0 answers
70 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
  • 403
2 votes
0 answers
431 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