Forum Discussion
Has anyone been able to reliably use Table.ColumnsofType() in Power Query?
I get random success/failures with this function. I have a table called Sales with several columns - number, text, Int64.Type, etc. The following in a new query returns nothing in the list. No er...
Indeed many thanks to @LarsSchreiber
His solution worked for me too with the numeric type as follows:
Table.ColumnsOfType(Patients1, {type nullable number})
I cannot believe I've been looking for this answer everywhere and this finally solved my problem. I was trying to bring back a list of all my text columns so I could replace text in all text columns but was only getting back 2 columns that had no nulls in them. 😎 This was the answer and SO simple.