Forum Discussion

JoanElGran1899's avatar
JoanElGran1899
Frequent Visitor
4 years ago
Solved

Sum Total Data Diff with one min(data created) and other max(data) about diferent tables

Hi everyone, May I ask for some help with an issue me and my team are facing. We are trying to sum the time our team spent doing invoices. So we are taking from 'Dim Invoice' (table) the doc ...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    JoanElGran1899 , Try like

    Sumx(addcolumns(summarize( 'Dim Invoice, 'Dim Invoice[Document no], 'Dim Invoice'[Created by]) , "_1", [Date diff invoice minute] )  , [_1] )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

JoanElGran1899 , Try like

Sumx(addcolumns(summarize( 'Dim Invoice, 'Dim Invoice[Document no], 'Dim Invoice'[Created by]) , "_1", [Date diff invoice minute] )  , [_1] )