DateDiff Errors

[swaxman]

I am pretty new to PowerBI

I am trying to do a DateDiff between two tables (OnboardingExcel which has unique records and TroubleTicket which has multiple records related to one ONboardingExcel record).  I have poked around on the forums and amelessly tried a couple solutions, but keep running into errors.

DATEDIFF('OnboardingExcel'[StartDate],'TroubleTicket'[Created_Date],DAY)

Error: A single value for column 'Created_Date' in table 'TroubleTicket' cannot be determined...

Days Past Start = IF(SUM(OnboardingExcel[StartDate])>SUM(TroubleTicket[Created_Date]),
DATEDIFF(SUM(TroubleTicket[Created_Date]),SUM(OnboardingExcel[StartDate]),DAY)*0,
DATEDIFF(SUM('OnboardingExcel'[StartDate]),SUM('TroubleTicket'[Created_Date]),DAY))

Error:Getting An invalid numeric representation of a date value was encountered.

Help is greatly appreciated!

[Greg_Deckler · Accepted solution]

Very difficult to tell what is going on without sample data and relationships.

For the first one, perhaps you are missing a relationship, or you have multiple trouble tickets with Created_Date that match your [StartDate]. You might try:

DATEDIFF('OnboardingExcel'[StartDate],MAX('TroubleTicket'[Created_Date]),DAY)

For the second on, you can't take a SUM of a true Date or Date/Time column. I would switch all of your SUM's to MIN or MAX.