- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
New Column error
So there seems to be a problem or I'm missing something.
When I create a New Column the first time, no problem, when I try and create a second one I get this error...
"A single value for Variation 'ColumnName' in table 'TableName' cannot be determined..... blah blah blah...
Now the thing is, that it seem to be when I try and use and IF function and try and type a field name after it.
But whats really weird is I took the code from the first New Column I created "That works" and plug it into another new column and the error pops up. And yes the field does exist example below...
It did not use to do this before the current May 2017 Update I loaded a couple days ago.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Stevil,
Please check if you create a calculated column or a measure. From the error message, it seems that you create a measure. Please click the New Column button then type this DAX again to see if the same error throws.
Best Regards,
Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Qiuyun Yu,
You are correct, I tried it with a New Column and I didnt get the errror.. My Bad.
Thank you very much for the quick response and have a great day.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Stevil,
It seems that the issue is solved now, right? Please mark a helpful reply as an answer so that we can close this thread.
Best Regards,
Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Stevil,
Please check if you create a calculated column or a measure. From the error message, it seems that you create a measure. Please click the New Column button then type this DAX again to see if the same error throws.
Best Regards,
Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
06-20-2024 08:14 AM | |||
02-07-2024 02:47 AM | |||
08-06-2024 07:19 AM | |||
06-05-2024 02:40 AM | |||
03-24-2024 08:42 PM |
User | Count |
---|---|
140 | |
110 | |
81 | |
60 | |
46 |