Forum Discussion

PBI_newuser's avatar
PBI_newuser
Post Prodigy
5 years ago
Solved

ENDOFMONTH duplicates error

Hi, I got an error for the below column. How to correct it? A date column containing duplicate dates was specified in the call to function 'ENDOFMONTH'. This is not supported.   Flag = if(AND...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    PBI_newuser ,based on what I got try like

    if(eomonth(Append[Travel Date],0)=eomonth(Append[Restoration Date].0) ,1,
    if(AND( Append[Travel Date] = eomonth(Append[Travel Date],0) ,
    (datediff(Append[Restoration Date], Append[Travel Date], month)<=1),1,0)))

amitchandak's avatar
amitchandak
Super User
5 years ago

PBI_newuser ,based on what I got try like

if(eomonth(Append[Travel Date],0)=eomonth(Append[Restoration Date].0) ,1,
if(AND( Append[Travel Date] = eomonth(Append[Travel Date],0) ,
(datediff(Append[Restoration Date], Append[Travel Date], month)<=1),1,0)))