Forum Discussion
New Measure - Cannot find name from table column
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"...
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])
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 )
)