title: Check if Power Query table is Empty then return something else
body: <p>I have a Power Query table that is pulling in Data from an ODBC connection, filtering that data and then returning it into excel. I then have several columns added to the table in excel that are utilizing the Excel networkdays formula. My issue is that occasionally the Power Query table will be empty and when empty the NetWorkdays formulas disappear from the excel table. </p>
  
  <p>My question is this. Is there a way to either check if Power Query is empty and return 0's or something else that will prevent the formula's in the excel cells from disappearing, or a way to prevent excel from removing the formula's if the table is empty?</p>