How to create calculated column with only some values of another column

[Anonymous]

Hi everyone,

I have a situation like the following:

I want to create another column only with Electricity coefficient. Final table must be like the following:

I don't want create Electricity Coeff. writing 0.0036 inside the formula because that value change when app is refreshed.

Any solution?

[v-zhangti · Accepted solution]

Hi, @Anonymous 

You can try the following methods. Find the minimum value of each ID.

Column:

Electricity Coeff. =
CALCULATE (
    MIN ( 'Table'[Coeff.] ),
    FILTER ( 'Table', [ID] = EARLIER ( 'Table'[ID] ) )
)

Does this match the output you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.