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
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies