Home

Extending Data Model Relationships

%3CLINGO-SUB%20id%3D%22lingo-sub-651994%22%20slang%3D%22en-US%22%3EExtending%20Data%20Model%20Relationships%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-651994%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I'm%20working%20my%20way%20through%3C%2FP%3E%3CP%3E%22Tutorial%3A%20Extend%20Data%20Model%20relationships%20using%20Excel%2C%20Power%20Pivot%2C%20and%20DAX%20%3CSPAN%3EExcel%202013%22%20and%20I'm%20using%20Office%20365%20ProPlus%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-gb%2Farticle%2Ftutorial-extend-data-model-relationships-using-excel-power-pivot-and-dax-cf7197d3-1938-490e-93fb-20371e8dd67a%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-gb%2Farticle%2Ftutorial-extend-data-model-relationships-using-excel-power-pivot-and-dax-cf7197d3-1938-490e-93fb-20371e8dd67a%3C%2FA%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3Eand%20when%20I%20try%20and%20create%20a%20relationship%20between%20the%20Events%20and%20the%20Medals%20tables%20by%20dragging%20the%20DisciplineEvent%20field%20from%20the%20Events%20table%20to%20the%20Medals%20table%20in%20Diagram%20view%20I%20just%20get%20a%20dashed%20line%20and%20if%20I%20double%20click%20on%20it%20and%20try%20to%20make%20it%20active%20it%20says%20%22Excel%2016%20only%20allows%20one%20filtering%20path%20between%20tables%20in%20a%20Data%20Model.%22%20The%20tutorial%20doesn't%20think%20there%20will%20be%20a%20problem%20at%20this%20point.%20See%20images%20attached.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20791px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F116242i7DBAF602B48E3D58%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture1.JPG%22%20title%3D%22Capture1.JPG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20759px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F116243i3C3CB07093BF2136%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture2.JPG%22%20title%3D%22Capture2.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ECan%20anyone%20help%20please%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EThanks%2C%20Robin%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%3E%3CDIV%20class%3D%22appliesTo%20collapsed%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-651994%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
robinireeves
Frequent Visitor

Hi, I'm working my way through

"Tutorial: Extend Data Model relationships using Excel, Power Pivot, and DAX Excel 2013" and I'm using Office 365 ProPlus

https://support.office.com/en-gb/article/tutorial-extend-data-model-relationships-using-excel-power-...

and when I try and create a relationship between the Events and the Medals tables by dragging the DisciplineEvent field from the Events table to the Medals table in Diagram view I just get a dashed line and if I double click on it and try to make it active it says "Excel 16 only allows one filtering path between tables in a Data Model." The tutorial doesn't think there will be a problem at this point. See images attached.Capture1.JPGCapture2.JPG

Can anyone help please?

Thanks, Robin

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies