daysleeper15
New Member
- Joined
- Jan 9, 2007
- Messages
- 35
I’m new to Power Pivot and am trying to create a simple concatenate but get an error.
I have a table which will be refreshed from time to time loaded into PP data model. I need to create a unique key using two text columns that I’d like to concatenate.
The first column in “Period” which is in format for example Jan 2019 - Dec 2019 and the second column is “Unit Code” in format 1234.
The table is in the pivot table, I go to table, right click, add measure and type:
CONCATENATE([Unit Code],[Period])
Check DAX Formula and get an error that says: this formula is invalid or incomplete. Calculation error in measure: The value for ‘Period’ cannot be determined. Either ‘Period’ does not exist, or there is no current row for a column named ‘Period’.
The error is confusing because period is definitely in the table and I can drag it into the pivot table and get no errors or anything.
Any idea what the problem could be?
I have a table which will be refreshed from time to time loaded into PP data model. I need to create a unique key using two text columns that I’d like to concatenate.
The first column in “Period” which is in format for example Jan 2019 - Dec 2019 and the second column is “Unit Code” in format 1234.
The table is in the pivot table, I go to table, right click, add measure and type:
CONCATENATE([Unit Code],[Period])
Check DAX Formula and get an error that says: this formula is invalid or incomplete. Calculation error in measure: The value for ‘Period’ cannot be determined. Either ‘Period’ does not exist, or there is no current row for a column named ‘Period’.
The error is confusing because period is definitely in the table and I can drag it into the pivot table and get no errors or anything.
Any idea what the problem could be?
