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

Count Number of Columns which as value

Hello Guys,

Need some help.

I have 20 Column and i have to create a column which should have a count of non blank columns.

2 REPLIES 2
Anonymous
Not applicable

create a new conditional column in Power query

if column[1], column[2], column[3], <> BLANK() = 1, BLANK()

Create a measure = COUNTBLANK ( newcolumn )

 

Hope this helps

 

Anonymous
Not applicable

@Anonymous I dont think it will work.Because i need it row wise,so i have to check for each row how many columns has a value.

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.