Custom Column with column names that have null registers
Hello everybody. I need some help here with a customer request.
My database is one that has several columns, including columns with the names of documents that the supplier needs to deliver to complete the registration process.
The client asked me to put a column with the documents that the supplier must deliver, so, I need a column that contains the name of the columns where the record of that line is null. As in DAX it is not possible to bring the column name, it needs to be in Power Query, and I'm having a lot of difficulties to do that.
Below is an example of the base and the expected result in the column "Documents Missing".