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] )

  • JoanElGran1899's avatar
    JoanElGran1899
    Frequent Visitor
    4 years ago

    Yess it works! By the way I want to ask you one more question, 
    I need only to sum the time in the same day of the 'Data created'


    For exemple the last line i don't want to sum it.

    Thank you