NEW DATASET WITH COLUMNS NAMES AND TOTAL NUMBER OF NO NULLS FOR EACH

[Claudiacccbb]

Crear una nueva tabla en power bi query que contenga en una columna los nombres de columnas de otra tabla y en otra columna que el total de valores no nulos de cada una de las columnas de la otra tabla.

[v-cgao-msft · Accepted solution]

Hi @Claudiacccbb ,

Suppose we have a table like this, and if I understand it correctly, try:

In Power Query Eidtor -> Reference Table -> select all column and unpivot columns -> group by [attribute]

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data