Power Query duplicate date error with no duplicates?!

macfuller

Active Member
Joined
Apr 30, 2014
Messages
257
Excel 2016 64-bit - Suddenly my calendar file that loaded just fine is throwing errors that there are duplicate dates, so it can't join to the other DAX tables. The query appears just fine in PQ but blows up when I try to load to the Excel data model.

These lines at the end don't make a difference

RemoveBlanks = Table.SelectRows(InsertedStartofWeek, each [Date] <> null and [Date] <> ""),
RemoveDupes = Table.Distinct(RemoveBlanks, {"Date"}),

Anyone else have this behavior? Solution?
 

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

macfuller

Active Member
Joined
Apr 30, 2014
Messages
257
No solution. I needed to add a column and expand the dates, so I created a new query with the same M that failed in the existing date table. It built the relationship to the other table with no problem.

So I had to rebuild the model to have everything point to the new date table, new Sort By column setup, replace all instances of the old date table with the new in slicers, timelines, rows and columns, redirect measures and calculated columns, delete all the old date relationships, and finally delete the query.

I hope there's an easier way that I didn't think of, since this might happen again!
 

Forum statistics

Threads
1,089,227
Messages
5,406,994
Members
403,117
Latest member
redblasko

This Week's Hot Topics

Top