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

66a1c94e 07fe-46d6-b0fd-6d75e603d168 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

29d1b9b0 ccbb-462a-9316-df362ee3fead 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

b290ede5 c0a7-4886-a86e-d7a37ca7d505 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

4828389c d97f-4615-8634-bcd14a45a393 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

65a98445 53c8-4fb0-bafa-0fa3942a14e4 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

10755e45 57bd-4e80-9326-8c5a300f0e80 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

457ca7a2 c6d3-41f2-972a-df6640c4faa7 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

7884ba69 0eb6-4e46-aff2-685127934578 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

0f441a79 caa6-4350-b1a5-086abcd45cb1 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!