Sequence contains more than one matching element

[Anonymous]

I get an error "Sequence contains more than one matching element" when apllying.

There are only two tables in the report. One is created by code on dax

DimDate =

ADDCOLUMNS (

    CALENDAR ("2024-01-01", "2024-09-29"),

    "DateInt", FORMAT ( [Date], "YYYYMMDD" )

)

The second is manually added one cell in Power Query.
Link to pbix
https://drive.google.com/file/d/1WC1NQijVKQbGVj-2IWNtsTdf-EiQBIRT/view?usp=drive_link

[Anonymous · Accepted solution]

Solve problem. I save file to .pbip format and delete all files in SemanticModel\definition\tables\.  In this folder was old defenition of tables.

[ahadkarimi]

Double-check your DimDate table for duplicate date entries.
You can use the following DAX formula:
DuplicateDates =
VAR Dates =
DISTINCT(DimDate[Date])
RETURN
FILTER(
DimDate,
NOT(Dates = EARLIER(Dates))
)

[Anonymous]

Table DimDate added via this code:

DimDate =

ADDCOLUMNS (

    CALENDAR ("2024-01-01", "2024-09-29"),

    "DateInt", FORMAT ( [Date], "YYYYMMDD" )

)

there can't be duplicates.

[Greg_Deckler]

@Anonymous Something is jacked up with that PBIX file. I would recommend turning off all preview features and then recreating that report from scratch. If I disable loading on the Table query and then try to delete the DimDate table, I still get that same error. 

You could check the Issues forum or open a support ticket but something isn't right about that PBIX file.

I have attached the stack trace