Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
@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())
@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())
User | Count |
---|---|
41 | |
27 | |
23 | |
19 | |
16 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |