Forum Discussion

RichOB's avatar
RichOB
Post Partisan
2 years ago
Solved

Adding a column

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...
Need Help
Show and Tell
  • AnkitaaMishra's avatar
    AnkitaaMishra
    2 years ago

    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

gokberkuzuntas's avatar
gokberkuzuntas
Regular Visitor
2 years ago

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.