cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mshaffer Frequent Visitor
Frequent Visitor

Creating new Calculated Table DAX FIRSTDATE has duplicate dates. That is not supported

Trying to create a calulated table that summarizes the dates by incidentID but keeping getting error of duplicate dates passed to FIRSTDATE even when I use the DISTINCT Function on those dates.  Not sure what is causing it as I can't debug the DAX statement at all DistinctDatesTable.jpg

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
mshaffer Frequent Visitor
Frequent Visitor

Re: Creating new Calculated Table DAX FIRSTDATE has duplicate dates. That is not supported

Resolved my issue through another route.  Made arelationship bi-directional and then used the FIRSTNONBLANK function to grab the acknowledge date.  Then mapped the AcknowledgeDate, MitigatedDate, and ResolvedDate to my table with a single status per incident.

 

Here is the DAX expression I used. Admittedly  I'm still a novice at using DAX expressions so I may still not be doing the most efficent method but it's working.

 

AcknowledgeDate1 = FIRSTNONBLANK('ArgusDevTeam ICM (All Status Changes)'[AcknowledgeDate], [AcknowledgeDate])

View solution in original post

2 REPLIES 2
Moderator v-caliao-msft
Moderator

Re: Creating new Calculated Table DAX FIRSTDATE has duplicate dates. That is not supported

@mshaffer,

 

I have tested it on my local environment, we cannot reproduce this issue.
Table = ADDCOLUMNS(SUMMARIZE(Table1,Table1[Type]),"FirstDate",FIRSTDATE(DISTINCT(Table1[Date])))
Capture.PNG

 

Please provide us some sample data, so that we can try to reproduce this issue and make further analysis.

 

Regards,

Charlie Liao

mshaffer Frequent Visitor
Frequent Visitor

Re: Creating new Calculated Table DAX FIRSTDATE has duplicate dates. That is not supported

Resolved my issue through another route.  Made arelationship bi-directional and then used the FIRSTNONBLANK function to grab the acknowledge date.  Then mapped the AcknowledgeDate, MitigatedDate, and ResolvedDate to my table with a single status per incident.

 

Here is the DAX expression I used. Admittedly  I'm still a novice at using DAX expressions so I may still not be doing the most efficent method but it's working.

 

AcknowledgeDate1 = FIRSTNONBLANK('ArgusDevTeam ICM (All Status Changes)'[AcknowledgeDate], [AcknowledgeDate])

View solution in original post

Helpful resources

Announcements
New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (2,699)