Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
Thank you for your support with the following query: count how many columns are empty at row level.
As you can see in the table there are several columns and some are empty, what I need is to know how many blank fields there are but horizontally that is, for each row
Hi,
It is easier to solve this in the Query Editor. If you want to receive further help, then share some data to work with and show the expected result.
One last question, should I apply the formula you provided as a column or as a measure?
Measure
Hello, from what I see in the formula, it is for it to count by columns, that is, from arrba downwards, what I need is for it to count from left to right the fields of a row
Let's imagine that I have the table "datos_personales" and this table only has one row of data and this table has 20 columns (name, age, gender, etc), some fields full and some empty, how could I know how many fields out of the 20 columns are empty.
Yes, so if you add this to a table (or matrix), with the rows populated by your rows in your master table, it will calculate it by row
You may try:
Empty Columns =
VAR USUARIO_CREA = IF(ISBLANK(Table[USUARIO_CREA]),1,0)
VAR USUARIO_LIBERACION = IF(ISBLANK(Table[USUARIO_LIBERACION]),1,0)
VAR N = IF(ISBLANK(Table[Column N]),1,0)
Return
SUM(USAURIO_CREA, USUARIO_LIBERACION, ... n)
Repeat for each column in N
If ISBLANK is returning you an error, try IF(Table[Column] = 0,1,0). Alternatively IF(Table[Column]="",1,0). Depending on the actual "value" of an "empty" column.
User | Count |
---|---|
92 | |
87 | |
77 | |
73 | |
68 |
User | Count |
---|---|
116 | |
107 | |
88 | |
65 | |
63 |