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

2 Replies

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

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    5 years ago

    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.