cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## 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.

Would really appreciate if someone can help me out on creating this calaulated column.

Thank you.

1 ACCEPTED SOLUTION
Super User

@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())

Super User

@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())