Forum Discussion
CAPSTALKER
Helper I
Helper IMeasure that replaces value based on another column's value
I have table of meetings and points for each type of a meeting. I need to replace values for meetings if value is 1 and based on a type of a meeting. If value is different than 1, it should return ...
CAPSTALKER are you adding new measure or column, it has to be a column
parry2k
Super User
Super UserCAPSTALKER add following expression as a column
Points = SWITCH( TRUE(), 'Meetings'[type] = "Training" && Meetings[Points] = 1; 3; 'Meetings'[type] = "New" && Meetings[Points] = 1; 5; 'Meetings'[type] = "Tech" && Meetings[Points] = 1; 6; Meetings[Points] )
CAPSTALKERHelper I
Helper II got an error:
A single value for column 'type' in table 'Meetings' cannot be determined.
- parry2k
CAPSTALKER are you adding new measure or column, it has to be a column