Forum Discussion

artfulmunkeey's avatar
artfulmunkeey
Helper I
5 years ago
Solved

Column from column values

Hi all,   I have another problem that I cannot solve and wonder if the community can help.   I would like to create new columns based on the entries in the existing column 'Account Name' summing ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hello @artfulmunkeey ,

    I don't quite understand why your 111222 account will be merged with account 100111 in the desired result.

    If you follow your table, the result may be this.

    Cost = IF([Account Name]="Cost",[Amount])
    Revenue = IF([Account Name]="Revenue",[Amount])

    6.png7.png

    More details can be found here.

    Best regards

    Stephen Tao

    If this post helps,then consider Accepting it as the solution to help other members find it faster.

darentengmfs's avatar
darentengmfs
Post Prodigy
5 years ago

Hi artfulmunkeey 

 

Go to Power Query Editor, duplicate your current table, remove all columns besides Trans.Date, Account Name, and Amount. Then, click onto your Account Name column, and pivot it, with the criteria sum of Amount.