Column Formula help

[Sivakumar_G]

Experts,

I need Year 1, year 2 and year 3 cost with respect to Cost A and Cost B columns. Can you please share the formula.

[amitchandak · Accepted solution]

@Sivakumar_G , You can have tree measure, as need of column is not very clear

year 1= Sumx(filter(Table, Table[Satge] in {"Incorp", "Operation"}), {CostA])

year 2= Sumx(filter(Table, Table[Satge] in {"Operation"}), {CostA])*2

year 3= Sumx(filter(Table, Table[Satge] in {"Operation"}), {CostA])*3

I do not see any date/year in data

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.