Custom formula in Advanced Editor - Power Query

Content Ideas
1

Hi Sam,

Came across an interesting technique to create a formula already in the Advanced Editor, either from a query or from a blank query and invoke it, so to avoid a calculated column or a heavy DAX formula in the model itself.

I find that on bigger datasets calculations such as banding or segmenting may slow down the model, hence my interest in this.

Maybe a good topic.

Paul

2

Sure thing. Can you share the specific idea that you saw?

3

See file attached. Custom formula added to the data in the Query Editor.
PQ formula.pbix (53.9 KB)

4

Thanks Paul.

Interesting.

I’m still not 100% as to what this is doing. Mainly because I can’t see what the raw data looks like.

image
image.png1391×339 24.3 KB

Able to share this as well?

5

Attached the Excel data file.
Custom formula.xlsx (16.3 KB)

6

Great thanks. Will review this one and add it to the list.

7

Thanks to the contributors of this post. Due to the length by which this post has been active, we are tagging it as Solved. For further questions related to this post, please make a new thread.