I have already created the queries by adding the data from Excel Tables (Click in the Table -> Click the Data Tab -> Click From Table).
Below is the syntax of the SUMX function in Power BI. In this article, we will take you through the SUMX in Power BI.