Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Add all the date differences in a table

Hi,

 

How can we add up all the date differences between two columns, I tried using sumx of all date differences but its not giving me right results.

 

 

Thanks,

 

Daniel

Need Help

2 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    HI Anonymous

     

    What result does it give you and what result are you expecting.

     

    Can you please post your SUMX calculation here

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Phil_Seamark,

       

      Below is what I get when I have sumx has a column or a measure.

       

       

       

       

       

       

       

      I am trying to calculate sum of all the values that are present under Dt_Diff column.

       

      Regards,

      Dan