Forum Discussion
How to write a code in Power Query that fills an empty query/table with a zero in a specific column?
Hi all, Is it possible to write a code that checks if the query in Power Query is empty or not and then fills in the 'Days taken to complete' as 0 if it is? For example, in the query below, there...
Hi PhilipTreacy ,
I'm having a few problems now with the code.
Image 1: there is a quick win in the table, and so it shouldn't try and load a new table
Image 2: because the code says 'else null', is just replaces the table above with null
I've tried changing null to "" but it just leaves the table blank that way, any suggestions?
Charlotte