Forum Discussion
Helper Ihow to Sum between two columns dynamically
Helper IHiya! The above column's are in a raw data file, no filters or existing relationships. I will try explaining my dataset.
So I want to create a table which one column is the Funder and the other would be the sum , sum being COWD project to date + Period 3 + Period 4 + Period 5. I would like to have an Option to determine what the current period is , and what the base line period is and sum everything in between. So hypothetically if I am in Period 5 atm, I want to be able to sum Period 4 and Period 5. .. If I am in Period 8 and I chose my baseline period to be Period 6, I want to be able to add Period 7 and Period 8 and Cowd Project to date.
So it would be nbice to be able to chose my current period and baseline period and add dynamically like that.
Community ChampionHi UrAvgWally
In order to do that the periods have to attributes in a one column [Period]. In order to do that you need to unpivot all the period columns using power query. It is a one click operation >> select the columns that need to be unpivoted, right click and select "Unpivot columns". But PLEASE BECAREFUL if you have large data, your file might crash. So please before doing anything PLEASE KEEP A BACKUP copy of your file. Once you do that, please let me know in order to guide you through the next steps.