Forum Discussion
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 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
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
4 Replies
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
Thank you, that's what I was after. Cheers
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.
