Skip to main content
Microsoft Idea

Power BI

New

PowerQuery M-Code: special symbol for previous step name

Vote (8) Share
Deniss Sipcenko's profile image

Deniss Sipcenko on 21 Oct 2022 16:23:26

UserStory: in 99% cases we use previous name as input for current step - very annoying and difficult to read, not comfortable to type and edit (it's always a double work).

Proposal: reserve some special symbol (#, for instance) for previous step name (like "_" for each)

This feature would be very useful for advanced users, who works more with Advanced Editor than with GUI.


Metacode Example:

Instead of this:

 let
    Source = someLoadDataFunction(...),
    #"Step 1"  = someFunction1 (Source, ....),
    #"Nice Step 2"  = someAdvancedFunction2 (#"Step 1", ....),
    #"Clever Step Name 3"  =  someVeryAdvancedFunction3 (#"Nice Step 2", ....),
    #"beautiful Step 4"  = someSmartCode4 (#"Clever Step Name 3", ....),
    Result     = someGeniousCode5 (#"beautiful Step 4", ....),
in
    Result


 It would be nice to use this syntax:

 let
    Source = someLoadDataFunction(...),
    #"Step 1"  = someFunction1 (#, ....),
    #"Nice Step 2"  = someAdvancedFunction2 (#, ....),
    #"Clever Step Name 3"  =  someVeryAdvancedFunction3 (#, ....),
    #"beautiful Step 4"  = someSmartCode4 (#, ....),
    Result     = someGeniousCode5 (#, ....),
in
    Result


Post with screens available here

Comments (1)
Deniss Sipcenko's profile image Profile Picture

Denis Sipchenko on 21 Oct 2022 16:39:53

RE: PowerQuery M-Code: special symbol for previous step name

Is it possible to edit posts?