unable to reference a field from a table

[JimB-GA]

Hello all,

I am pretty new to Power BI and am on a steep learning curve.  I have a table that I cannot reference in a measure.  I can create measures successfully referencing every other table.  For example:

 I have a table I have named "Current"

Trade Time	Last	Change	% Change	Open	High	Low	Volume	T1	TIme
1547758619	262.81	1.8299866	0.701198	260.01	263.915	259.96	77,245,081	17913.6646050926	01/17/2019 03:57:01 PM

I am attempting to create a new measure in another table that references the "Last" field in table "Current" but when I look for the available field [Last] I cannot find it.

Is there some naming reference that I need to add to show this table and field in creating a new measure?

Thanks to all for your help.

JimB

[Anonymous]

error, canot find column name .

can anyone help me

[AlB]

Hi @JimB-GA

Can you show the code where you get the problem and the error message?

Can you, ideally, share the pbix indicating where the problem is?

[JimB-GA]

Hi, and thanks for reply. I cannot reference a field from one table to another in calculation.

My objective is to create a measure Total_Cost =[Last] (from Current table)-[New Price] (from Transactions

When I attempt to insert Measure  =[Last] in the 'Transactions' table, the error reads 

"The value for 'last' cannot be determined.  Either 'last' doesn't exist or there is no current row for a column named 'last'.

I have inserted link to file Test.PBIX in dropbox to illustrate. 

https://www.dropbox.com/s/z585zgpfbtraiyc/test.pbix?dl=0

Thanks

Jim

[JimB-GA]

Thanks so much for this solution.  Works like a charn..

Jim

[v-cherch-msft]

Hi @JimB-GA

If you want to create a measure,you may use SUM Function as below.Total_Cost=SUM('current'[Last])-SUM(Transactions[New Price]).If it is not your case,please explain more about your expected output.

Measure = SUM('current'[Last])

Regards,

Cherie

[AlB · Accepted solution]

@JimB-GA

You cannot reference a "naked" column within a measure. In a measure there is no row context so the engine does not know what row you are referring to. Have a look at this and or this

I would also stick to always using fully qualified names for columns, i.e. TableName[ColumName] instead of just [ColumnName]. The latter is best reserved for referring to measures:  [Measure]