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

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.