Forum Discussion
Solved
Create column based on other columns
Hi, I have following table and would like to recreate res column. id time val res A 1 12 12 A 2 9 12 A 3 15 12 B 1 24 24 B 2 22 24 B 3 27 24 ...
If Min time can be other than 1, then this column
Res = VAR Mintime = CALCULATE ( MIN ( TableName[time] ), ALLEXCEPT ( TableName, TableName[id] ) ) RETURN CALCULATE ( MIN ( TableName[val] ), FILTER ( ALLEXCEPT ( TableName, TableName[id] ), TableName[time] = Mintime ) )
If Min time is always 1, then you can use
Res =
CALCULATE (
MIN ( TableName[val] ),
FILTER ( ALLEXCEPT ( TableName, TableName[id] ), TableName[time] = 1 )
)
Thanks. What about if Val column is text? What can be used instead of minimum to get that text to new column. This is just extra but would like to know.
- Hi
You can also use
Selectedvalue or Values