New Measure - Cannot find name from table column

[Anonymous]

Hello guys,

I'm learning my ways through power bi and this is the issue now.

I'm trying to create a new measure for this table below and when I mention [EOY] give me the error "cannot find name".

Help ?? 😅

BR

[Anonymous]

Thank you all for the support. Adding SUM previouly recognized my EoY column

[TomMartens]

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

[AlexisOlson]

When you reference a column without a table name in this context, it thinks you're referring to a measure. Even if you qualify it with the table name, you still need an aggregation on it or it will throw an error since it doesn't know what row(s) you want.

Try this:

KPI =
SWITCH (
    TRUE (),
    SUM ( Board[EOY] ) < 0, UNICHAR ( 9660 )
)

[Anonymous · Accepted solution]

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])

[pginez22]

Hi, I'm having a similar error with a measure, this is the code tham I'm using and error that I'm getting.

please help!!