Forum Discussion

pkoetzing's avatar
pkoetzing
Advocate III
3 years ago

Summarize virtual table

I have a calculated table Combine work per date = UNION( SELECTCOLUMNS( 'Work', "Date', <expression>, "Minutes", <expression> ), SELECTCOLUMNS( 'Work', ...
Need Help
pkoetzing's avatar
pkoetzing
Advocate III
3 years ago

Thanks for the hint with SUMX, but in a measure I could even use

Aggregate work per date = 
VAR tbl = 'Combine work per date'
RETURN
    SUMX ( tbl, [Minutes] )

which includes a table variable.