Forum Discussion
Power Pivot Relationship Between Tables Done, Still Getting Duplicate Values, Suspect Date is Text.
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
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 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.
Done, signed up! In the meantime I'll study up on the hows and why's of what you did - its what you put where, that they are not table columns but functions - I think theres some interesting stuff there for me. Again, many thanks!