Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DateDiff sum

Hello  -  I would like to, using DAX or mquery, fix the issue I am having below.    Trying to sum up the days between when a Lead is created by our salespeople....and when that actual account  (from ...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi Anonymous ，

     

    You can go to data view>select the calcualted column>column tools>"dont summarize":

    And when you put the column value in a visual you will see:

    The valued is not summed up automatically.

     

     
    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!

     

az38's avatar
az38
Community Champion
6 years ago

Anonymous 

this behaviour ais explained by that fact that you have a few rows with the same pair Lead - Acc dates.

you need to define business logic how do you want to calculate cases with two identical date's pairs