ENDOFMONTH duplicates error

[PBI_newuser]

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 (MONTH(Append[Travel Date])=MONTH(Append[Restoration Date]) , YEAR(Append[Travel Date])=YEAR(Append[Restoration Date])),1,
if(AND( Append[Travel Date] = ENDOFMONTH(Append[Travel Date]) ,
    (((Year(Append[Restoration Date])-Year(Append[Travel Date]))*12) + Month(Append[Restoration Date])-Month(Append[Travel Date]))<=1),1,0))

[v-lionel-msft]

Hi @PBI_newuser ,

Or is this what you want?

Flag = 
IF(
    MONTH([Travel Date]) = MONTH([Restoration Date]) && YEAR([Travel Date]) = YEAR([Restoration Date]),
    1,
    IF(
       [Restoration Date] = ENDOFMONTH('Append'[Travel Date]) && DATEDIFF([Restoration Date], [Travel Date], MONTH ) <=1,
        1, 0
    )
)

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@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)))