I am struggling with the following.

I am struggling with the following.

I have this written in DAX but I actually have to write it in Power Query. I need a column that adds a 1 if the other columns do not equal “NA” and then adds the 1s together. So if column 1, 2, and 3 were yes and column 4 and 5 were NA then the new column would be the number three.

I am loading 100s of XML files from a folder and Power Query has created a function from the first file that I had loaded. The problem is not all the XML files have similar structure. Some have nodes that don’t exist in other XML files. I can’t change the source system which generates this.

I’ve been working on a query with lanquage M that takes a table and gives me the column count the problem is in the query Edito it looks fine but when I load and close the query in the table view I don’t see that value .

What would be a good method to get the labeled column names below to be placed as the actual column names for the numeric fields in the (abridged) text file below?

I’ve got a folder with thousands of JSON files that I’m trying to import into PowerBI. I’m getting the following error with at least one of the files, but it’s difficult to tell which one it is and how to resolve it.