Forum Discussion
KristyP
Helper I
Helper IDAX Calucation
Hi, I have two related tables. I am trying to find a value in one table based on a range ( min & max) and a category from the first table. The value I require is in the second table, seperate col...
Sure, I can do this tomorrow.
KristyPHelper I
Helper IThank you,
I have tried your solution, but am getting the followinf error:
A single value for column 'Product Group' in table 1 cannot be determined. This can happen when a measure refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.
tamerj1
Community Champion
Community ChampionKristyP
This is supposed to be a calculated column in Table1 not a measure.
- KristyP
I haved used this calculation. But there are some issues with it not always picking up the correct value. This issue does not seem relate to any one particular Product Goup or band. Any ideas what could be casuing this issue?