Skip to main content

Power BI

Completed

DAX Editor in Power BI Designer

Vote (358) Share
Marco Russo's profile image

Marco Russo on 18 Dec 2014 07:32:38

It would be important being able to create calculated columns and measures in DAX in a data model created with Power BI Designer

Comments (12)
Marco Russo's profile image Profile Picture

Driss Arabe on 05 Jul 2020 22:21:58

RE: DAX Editor in Power BI Designer

Hi Team
in Multi questions the answers are multis columns , os has some one use manipulation for merging multis questioss and get a % for all answers
Thanks

Marco Russo's profile image Profile Picture

Tim Rodman on 05 Jul 2020 22:01:04

RE: DAX Editor in Power BI Designer

In Excel 2010, they were called "Measures".

In Excel 2013, they changed the name to "Calculated Fields".

In Power BI Designer, they are called "Measures" again.

I hope that they change it back to "Measures" in Excel 2016 because it sounds a lot "smarter" than "Calculated Fields".

Side note: They are also called "Measures" and Qlik

Marco Russo's profile image Profile Picture

Taylor on 05 Jul 2020 22:00:49

RE: DAX Editor in Power BI Designer

Is there a timeline for when DAX might be available on the Web App? Works great on the desktop version!

Marco Russo's profile image Profile Picture

Owen Power BI User on 05 Jul 2020 22:00:43

RE: DAX Editor in Power BI Designer

In Power BI Designer Preview version 2.22, when right-clicking on an existing table, the "New Column" option for creating a DAX calculated column doesn't seem to exist (but "New Measure does). Does anyone know if this is as intended?
Possibly it's just available in the paid version?
Confused as there is a tutorial on creating DAX Calculated Columns here:
https://support.powerbi.com/knowledgebase/articles/590610

Marco Russo's profile image Profile Picture

Tim Rodman on 05 Jul 2020 22:00:36

RE: DAX Editor in Power BI Designer

I really like how the look/feel is just like the formula editor in Excel. Nicely done.

And the new CONCATENATEX function is awesome.

Marco Russo's profile image Profile Picture

Martin Aronsson on 05 Jul 2020 21:58:49

RE: DAX Editor in Power BI Designer

DAX-support very important for this tool to be useful

Marco Russo's profile image Profile Picture

Lance Delano on 05 Jul 2020 21:58:49

RE: DAX Editor in Power BI Designer

DAX functionality is on its way.

Marco Russo's profile image Profile Picture

Power BI User on 05 Jul 2020 21:58:24

RE: DAX Editor in Power BI Designer

Really anxious to know when DAX will be available in Power BI Designer. Why can't the largest software company in the world give us a roadmap for Power BI, as per this article?

http://businessintelligist.com/2015/03/01/what-is-power-bi-designer-and-why-you-should-start-playing-with-it-right-now/#comments

Thanks.

Arthur Jenkins

Marco Russo's profile image Profile Picture

Power BI User on 05 Jul 2020 21:58:04

RE: DAX Editor in Power BI Designer

Having calculated columns and calculations in DAX is an obvious necessity. So a +1 here.

Marco Russo's profile image Profile Picture

TJ Brown on 05 Jul 2020 21:58:00

RE: DAX Editor in Power BI Designer

Being able to see the embedded data model would also be beneficial for defining data types, renaming columns, and defining default aggregations. Please add!