How to add rows of columns

[Anonymous]

Hi there,

I need to create a planning indicator in my table. Let me explain. Our projects are done in several key phases: Go dev, Go Implementation, Main PO, GO production and closing date. The project manager must fill in these 5 dates for the project to be completed. Now, I have to create a column in a table that would work as follows: when the project manager only fills in the first two dates (go dev and go implementation), the indicator is red, 3 dates (therefore go dev, go implementation and main PO) the indicator is orange and if the 5 dates are filled in there is a green indicator.

At first to exploit the data which is in the form of a date, I created 5 columns which transform the information into binary: 0 if the box is empty and 1 if it is filled. So I have my 5 columns and my idea was to create a 6th one which sums the 5 previous rows and so I have numbers from 0 to 5 and I will be able to put in conditional form in my table. The thing is that I can't find a formula that allows to add the rows and not the columns. Can anyone help me ?

Thanks !

Emilie ❤️

[Greg_Deckler · Accepted solution]

@Anonymous Not sure I completely understand. You add columns like:

[IndicatorGoDev] + [IndicatorGoImple] + [IndicatorGoMainPO] + [IndicatorGoProd] + [IndicatorClosing] 

That would give you a single value between 0 and 5 for each project

You add rows like:

SUM('Table'[IndicatorGoDev])

But I'm not understanding why you want to add rows.

[Anonymous]

@Greg_Deckler ,

I'm sorry if I wasn't clear, but your formula worked! In fact I do not master Power BI well so I do not know the formulas to use (so I did not know that I could simply do [IndicatorGoDev] + [IndicatorGoImple] + [IndicatorGoMainPO] + [IndicatorGoProd] + [IndicatorClosing] )

So now I have my Planning column ! 

Thanks to you 🙂