Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

How to add rows of columns

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.

Milou190_3-1663665635401.png

Milou190_2-1663665559490.png

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 ❤️

1 ACCEPTED SOLUTION
Greg_Deckler
Community Champion
Community Champion

@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.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Greg_Deckler
Community Champion
Community Champion

@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.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

@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 🙂

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.