Forum Discussion
Using DATEDIFF WHERE ColumnD = XX??
Hi, Does anyone know how to take the DATEDIFF of two date columns where another column equals a specific value. In my pseudo code :-) CycleLength = (DATEDIFF('Sales Leads[Created],'Sales ...
Thanks for the reply. However, when I try and run this it comes up with an error.
The actual error is 'A single value for column 'Created' in table 'Sales Leads' cannot be determined. This can happen when a measure formula refers o a column that contains many values without specifying an aggregation sum, min or max to get a single result'
Same issue for 'Modified' too. Is it because these are dates?
Any ideas?
Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.
Regards,
Jimmy Tao