Forum Discussion

pkoetzing's avatar
pkoetzing
Icon for Advocate III rankAdvocate 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
jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
3 years ago

You should be able to do it with a SUMX like this.

Aggregate work per date =
SUMX (
    VALUES ( 'Combine work per date'[Date] ),
    CALCULATE ( SUM ( 'Combine work per date'[Minutes] ) )
)