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...
Anonymous , Try like
if [Days taken to complete] = null then 0 else [Days taken to complete]
Hi, I think the problem is that there is nothing there, not even 'null', so unsure if it would be able to detect anything?