Adding a column

[RichOB]

Hi, I'm having a brain slip here.

I need to add a new column to the Transform Data page and make it average the 4 areas. How do I do this? I'm not looking to get this as a measure but to build it in as a column, please.

Date	North	South	East	West	Average
01/01/2024	3	4	3	5	3.75
01/02/02024	6	7	8	5	6.5
01/03/2024	8	4	7	6	6.25

Thanks

[gokberkuzuntas]

Hello @RichOB,

There are two option you can create as column. Which are transform side(Power Query) and New Column(front side, DAX). But you would like to solve the problem in the Power Query side. So, in power query side "Add Column --> Custom Column" and you can write a code such as ([North]+[South]+[East]+[West]) / 4

Best Regards,
gokberkuzuntas

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

[Ritaf1983]

Hi @RichOB 
There is no way to achieve the desired result without creating measures.

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

[AnkitaaMishra · Accepted solution]

Hi @RichOB ,
You can create the column by following below steps : 
1) go to transform page 
2) Click on Add Column tab
3) Choose custom column and write the formula highlighted below : 

Please let me know if this helps or share more details on your requirement.

Thanks,

Ankita

[RichOB]

Thank you, that's what I was after. Cheers