• We are receiving reports of members using the private messaging service (Conversations) in ways that break the forum rules:
    • Do not invite another member to take the question off the forum (i.e. do not suggest that they post to a different forum, do not suggest that they email or private message you the problem, do not simply post a link to another forum, unless it is to a specific, relevant, thread). This applies equally to members asking or answering questions.
    • Soliciting business for yourself is not permitted. This is an all volunteer board, so offering solutions in exchange for compensation is not permitted. Likewise, members seeking solutions must not offer compensation for them. If you have an urgent need, check the Consulting Services page.
    Please help us out by clicking the Report link on any messages you receive that violate these rules. Thank you
  • If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
    If you forgot your password, you can reset your password.

Power Query duplicate date error with no duplicates?!

macfuller

Board Regular
Joined
Apr 30, 2014
Messages
246
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?
 

macfuller

Board Regular
Joined
Apr 30, 2014
Messages
246
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,077,965
Messages
5,337,441
Members
399,147
Latest member
Raviteja KOTHA

Some videos you may like

This Week's Hot Topics

Top