Skip to main content

Power BI

Needs Votes

Advanced Editor for DAX Columns and Measures

Vote (19) Share
Jon's profile image

Jon on 18 Aug 2017 05:28:01

I would like to see an editor where I can define all of my DAX columns and measures similar to Advanced Editor for Power Query/Query Editor. Though I would like to see it with a C# scripting syntax by defining the object type, and delimiting EOL using a semicolon.

Idea:
column _dcMyColumn1 = IF(this = BLANK () , that, this);
column _dcMyColumn2 =
VAR sOther = "Something"

RETURN
IF(
this = sOther,
that,
this
);
measure _dmMyMeasure = DISTINCTCOUNT(Table[Id]);
measure _dmMyMeasur2 = SUM(Table[Cost]);

Comments (3)
Jon's profile image Profile Picture

Jeroen Habets on 16 Aug 2020 04:09:34

RE: Advanced Editor for DAX Columns and Measures

Main benefit would be that we could copy and reuse snippets of configuration of DAX (like we can in M).

I'm actually surprised there is no "View/Edit Source" already...

Jon's profile image Profile Picture

Jeroen Habets on 16 Aug 2020 04:09:34

RE: Advanced Editor for DAX Columns and Measures

BTW: I voted for the "Advanced Editor" idea, in my opinion it should contain DAX and not C#.

Jon's profile image Profile Picture

Power BI User on 16 Aug 2020 04:02:57

RE: Advanced Editor for DAX Columns and Measures

Here here!