Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to stop enumeration error in power query

Hi,

 

I've created an overview page for the CI initiatives we are doing (see below), however in Power Query the way I have set it up is that the Quick Wins/Local Projects are only those completed from this month. And the Last Month's Quick Win/Local Project is obviously last months completed CI's, and then to find the trend, I subtract the last month by the current month to find the difference. If no CI has been completed for this current month, then the overview sends the error message below because there are no CI's listed in that table, and from this, it then won't update any of the other metrics because that one data file can't be refreshed. Is there any way to make sure the others load even if that one does not? Thanks in advance

 

1 Reply