Adding starting value to column

[Anonymous]

Hi all,

I am trying to get a  Power BI version of this excel formula

December 2020	January 2021
100	=B2+SUMIF(....)
200	B3+SUMIF(....)

Currently I have a table with the December 2020 values and another table with the values from Jan 2021-Dec2021

Is there a way to add the December values to January and the sum of that to Februrary and so on?

I assume it may have to do with creating calculated columns?

Thank you in advance!

[v-kelly-msft]

Hi @Anonymous ,

What is the data structure of values in Dec 2020?Does Dec 2020 only have 2 values?How to add the values to 2021?Are the values added correspondly on each row?

If possible,could you pls provide some sample data with expected output?I would help to create the calculated column.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[mahoneypat]

Looks like you should unpivot all your month columns and then create a running total measure.

Pat