Help simplifying conditional column

Borjaveigasvh — Sat, 04 Jul 2020 14:25:06 GMT

Good Afternoon,

Maybe someone has a tip for this kind of calculated column.

My table has 6 columns with diferent values for each row. not all columns have values, in order to determine how many columns have value in each row an qualify the completness of each row, I was thinking on creating a conditional column. but combinations are very high and that would give me a very long conditional formula.

I would like to see if a row has 1, 2, 3, 4, 5 or 6 columns with value

First one is easy because I only have to write it with an OR bolean, 6 is also easy bacause I just need to write the bolean And but the rest is a nightmare.

Any solutition that makes it simplier?

Thanks Community!!

Re: Help simplifying conditional column

lbendlin — Sat, 04 Jul 2020 19:41:42 GMT

You can abuse the logical true as a number.

Calculated column= sum(column1>blank + column2 >blank + ...)

Might need additional encapsulation.

Re: Help simplifying conditional column

Borjaveigasvh — Sun, 05 Jul 2020 10:33:20 GMT

True! Thanks I din't see it that way.

Many thanks

Borja

topic Re: Help simplifying conditional column in DAX Commands and Tips

Help simplifying conditional column

Re: Help simplifying conditional column

Re: Help simplifying conditional column