Forum Discussion

Quynhtran's avatar
Quynhtran
Regular Visitor
5 years ago
Solved

Return values from conditional column within each group

Hello everybody,   I would like to create new column [Name Revised], which updates the correct name for each ID. For example, if there are in the same ID, the correct name is the name that have the...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

     

    Name Revised CC =
    VAR _currentID = Data[ID]
    VAR _mindate =
    CALCULATE ( MIN ( Data[Date] ), FILTER ( Data, Data[ID] = _currentID ) )
    RETURN
    CALCULATE (
    DISTINCT ( Data[Name] ),
    FILTER ( Data, Data[ID] = _currentID && Data[Date] = _mindate )
    )

     

     

    Link to the pbix file 

     

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

 

Name Revised CC =
VAR _currentID = Data[ID]
VAR _mindate =
CALCULATE ( MIN ( Data[Date] ), FILTER ( Data, Data[ID] = _currentID ) )
RETURN
CALCULATE (
DISTINCT ( Data[Name] ),
FILTER ( Data, Data[ID] = _currentID && Data[Date] = _mindate )
)

 

 

Link to the pbix file 

 

 

Quynhtran's avatar
Quynhtran
Regular Visitor
5 years ago

Thanks Jihwan,

It works perfectly.