Count Number of Columns which as value

[Anonymous]

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.

[Anonymous]

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]

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