Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Change column attributes (DAX formula)

  I would like to change "Type" column attributes by creating a calculated column. The "type B" is more valuable than the "type A". So, for each person in the table, if we have both types then...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , A new column

    new column =

    var _cnt = countx(filter(Table, Table[ID] =earlier([ID]) && [Type] = "Type B") , [ID])

    return

    if(isblank(_cnt), [Type], "Type B")

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , A new column

new column =

var _cnt = countx(filter(Table, Table[ID] =earlier([ID]) && [Type] = "Type B") , [ID])

return

if(isblank(_cnt), [Type], "Type B")