Forum Discussion
New Measure - Cannot find name from table column
Hi ucoxa,
You can't reference the column as part of a measure without using one of the aggregation functions in DAX. It depends on what you want to achieve.
A couple examples might be SUM() or SUMX. See link above.
Should look like this as an example---> SUM([EOY])
Hey Anonymous ,
when you create a measure, you have to wrap the column reference in an aggregate function like MAX(...), this is always valid except there is an existing row context created by functions FILTER or table iterator functions like SUMX(...).
Next to that it's being considered to reference a column name together with the table name like tablename[columnname]. There are also people, like me who always write a column reference like so 'tablename'[columnname]. The ' is needed if there is a space in the table name.
Best practice
column name reference: 'tablename'[columnname]
measure reference: [measurename]
It helps to distinct between the reference of column name and a measure name.
Next to that, across the dataset there could be multiple columns with the same name, but just one measure.
Hopefully, this provides some insights and will help to tackle your challenge.
Enjoy learning DAX.
Regards,
Tom