Forum Discussion
sumifs doesnt work because of power query
Hi All, I've been trying to automate some regular reports using power query. The queries for the different reports are working and everything is fine, however I want to use those query tables and s...
In the Power Query Editor, click Home → Close and Upload → Create Connection Only to refresh the data, the SUMIFS function will be able to calculate the results normally, and it should be noted that the text format is not supported!