Calculate individual cells, such as in Excel

[Anonymous]

Hello, everyone,

Any chance Power BI can provide individual calculation (per cell) such as Excel does? Preciselly, I'd like to summarize (in a new table), on 3 different columns (New, Existent, Churned), the sales amount throughout 6 years.

The table from where I'd like to summarize has columns like January2017, February2017,..., December2022 (these are literaly the names of the columns, with respective values).

What I'm shooting for is a result like below:

Year   Month          New($)             Existent ($)    Churned ($)

2017  January         Jan17 new       Jan17 ex       Jan17 ch

2017  February       Feb17 new      Feb17 ex       Feb17 ch

...

2022  December     Dec22 new     Dec22 ex       Dec22 ch

So, is there a way of replicating the good old fashioned Excel's =SUM(January2017) etc. from the main table, in the new one, indivdually by cell?

Much appreciate it!

[ERD]

Hi @Anonymous ,

I'd suggest you to unpivot those columns (Jan-17, Feb-17,...) in Power Query first.

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

[Anonymous]

Hi, @ERD,

As I've created the calculated columns in Data View, I cannot see them in Power Query. Is there a way to make them visible, or another way of unpivoting them, outside Power Query?