Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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 that Lead) gets created.   

 

The 3rd column is correct  -  acheived by selecting the "do not sum" option in the visualization area.     The far right column is what happens if I don't, and just leave it as "summarize".  

 

Is there a way to achieve having this calculated column  NOT sum, within the formula itself?     Or perhaps can a measure be created instead?    Thanks!

 

 

 

datediff .png

1 ACCEPTED SOLUTION
v-kelly-msft
Community Support
Community Support

Hi @Anonymous ,

 

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

Annotation 2020-06-01 094719.png

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

Annotation 2020-06-01 094501.png

The valued is not summed up automatically.

 

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

 

View solution in original post

2 REPLIES 2
v-kelly-msft
Community Support
Community Support

Hi @Anonymous ,

 

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

Annotation 2020-06-01 094719.png

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

Annotation 2020-06-01 094501.png

The valued is not summed up automatically.

 

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

 

az38
Community Champion
Community Champion

@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


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.