Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculate new column based on condition

Hi,    I have a dataset as below (left) and I need to add another column (right) based on this condition:   1. Sum of all ACT value and first subsequent FC from column ACT_FC.       Wou...
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try a new column like

     


    new column =
    var _min = minx(filter(Table, Table[ACT_FC] = "ACT"), [Period])
    var _vol = Sumx(filter(Table, Table[ACT_FC] = "ACT"), [VOlume])
    var _minFC = minx(filter(Table, Table[ACT_FC] = "FC"), [Period])
    return
    if( [Period] = _min , Sumx(filter(Table, Table[ACT_FC] = "ACT"), [VOlume]) + Sumx(filter(Table, Table[ACT_FC] = "FC" && [Period] = _minFC), [VOlume]), blank())

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

Anonymous , Try a new column like

 


new column =
var _min = minx(filter(Table, Table[ACT_FC] = "ACT"), [Period])
var _vol = Sumx(filter(Table, Table[ACT_FC] = "ACT"), [VOlume])
var _minFC = minx(filter(Table, Table[ACT_FC] = "FC"), [Period])
return
if( [Period] = _min , Sumx(filter(Table, Table[ACT_FC] = "ACT"), [VOlume]) + Sumx(filter(Table, Table[ACT_FC] = "FC" && [Period] = _minFC), [VOlume]), blank())