Forum Discussion
FIRSTDATE() Error
"A date column containing duplicate dates was specified in the call to function 'FIRSTDATE'. This is not supported." I am trying to get the first outcome date for a referral. I have an OUTCOME ta...
HiJpTall,
Do you use the time intelligence function with a calendar table? If not, it can also cause this error.
Did this error message occur when you tried to graph it? If so，after you have dragged the new column into a graph in Power BI, you can try setting the way it aggregates to “Do Not Summarize".
Hope it helps.
Best Regards,
Caitlyn Yan
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.