Forum Discussion
yasbos
2 years agoResolver II
Summarizing a second table variable doesn't work right
Good day, friends! In the below code, I'm summarizing the duration per subtask. If the task has no end date, I'm calculating the duration as being the difference between the start date and today's da...
amitchandak
2 years agoSuper User
yasbos , A new column with Sumx and table TotTimeTask, will sum up all the data of that table in column
Try groupby with current group
refer
https://medium.com/@amitchandak/power-bi-power-query-vs-dax-append-and-summarize-data-233f173d0839
- yasbos2 years agoResolver II
I get the below error.
function group by scalar expressions have to be aggregation functions over currentgroup(). the expression of each aggregation has to be either a constant or directly reference the columns in currentgroup()