Forum Discussion
Creating measure and calculated column in Advanced Editor using M language
How can I create measure and calculated column in Advanced Editor? And I don't see the calculated column shows up in the Advanced Editor as well. I am inquiring this because I need to create simi...
Hi,
Measures and calculated columns are writtein in the DAX language by going to the Modelling tab. They cannot be written in the Query Editor.
Hi,
Once can only create one measure at once and use that in unlimited visuals.
If you have highly similar columns and you want to quickly "copy-paste" the measures from table to another then I would consider using a clever naming convention coupled with the following "horrible" dax formatting for the measures:
MeasSumTable1 = SUM(
Table1
[Column1]
)
This way you can minimize the clicks and other mechanical msucle movements needed for each copy-paste. But it ain't pretty code! 😄