Forum Discussion
SUM FOR BIG ROW
there is a column for each day for the year including amount of sales for each store, i need to sum all sales for each branch for all the year, i need to sum the full row,
Hi amaher
Your table is not in the best format for reporting. Each period must have its own row as below.
In the query editor, select the first two columns and click unpivot other columns. Please refer to this - https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098
This is Power Query in Excel but the GUI is about the same as in Power BI.