siddiqi1980
New Member
- Joined
- Jan 12, 2016
- Messages
- 1
Dear
I try to use left function to 2 digit form account column "LEFT('Main Data'[Account],2)" but is not working.
this error came when i check formula in filed calculation
"Calculation error in measure 'Main Data'[ABC]: The value for column 'Account' in table 'Main Data' cannot be determined in the current context. Check that all columns referenced in the calculation expression exist, and that there are no circular dependencies. This can also occur when the formula for a measure refers directly to a column without performing any aggregation--such as sum, average, or count--on that column. The column does not have a single value; it has many values, one for each row of the table, and no row has been specified."
ABC is new Field Name
Main Data is Table name
Account is column from where is try to get data. it is also in TEXT format.
please help me to calculate is formula
Thanks & Regards
I try to use left function to 2 digit form account column "LEFT('Main Data'[Account],2)" but is not working.
this error came when i check formula in filed calculation
"Calculation error in measure 'Main Data'[ABC]: The value for column 'Account' in table 'Main Data' cannot be determined in the current context. Check that all columns referenced in the calculation expression exist, and that there are no circular dependencies. This can also occur when the formula for a measure refers directly to a column without performing any aggregation--such as sum, average, or count--on that column. The column does not have a single value; it has many values, one for each row of the table, and no row has been specified."
ABC is new Field Name
Main Data is Table name
Account is column from where is try to get data. it is also in TEXT format.
please help me to calculate is formula
Thanks & Regards