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 Anonymous
The code I posted is created from a sample of columns I manually entered into PBI. If you can please post a sample of your data with the table names in order, I can rewrite the code for you. You don't change the Table.FromRows in my code, it will break the code.
Thanks
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.