Forum Discussion
Solved
Power Pivot Relationship Between Tables Done, Still Getting Duplicate Values, Suspect Date is Text.
H Folks, I've been at this all day. Because of relationship issues (and I suspect the underlying reason is the dates, while appearing as dates in the file, are actually still text I believe)...
You need Calendar table (now is usually named as Date). I generate it in Power Pivot, better do that by Power Query, you may find a lot of templates. Model will be
and PivotTable is
Something strange happened - when I just tried to login to my microsoft account, the language was all Pinyin. I'll bet the operating system is seeing the .csv date as text. Taking the computer in Tomorrow.
You need Calendar table (now is usually named as Date). I generate it in Power Pivot, better do that by Power Query, you may find a lot of templates. Model will be
and PivotTable is
- I can't believe this! That is something that will be so helpful, I can't wait to apply it to the model I have to re- build now.
I googled and studied this problem from every angle. This is a "bridge table" yes?
Why did my account bridge table not work where your yours does? Is it an applicable solution for every type of relationship table
Just trying to figure out the logic.
Thank you again, for me who is just learning dax measures to add more meaningful context to power pivot tables, this will be a deal changer and I can move forward instead of spending the whole day googling on one problem.- Not only that, looks like I need to study power pivots in general more.
On this journey I'd recommend to check Home - SQLBI where everyone who deals with DAX, from beginner to Pro, could find a lot of useful information. There are a lot of other great resources, but this is one of the best.