Power pivot relationship

[dicken]

Hi,
I had a relationship that wasn't being recognized so I deleted it and recreated it but this time dragged from many side to one side, and it started working?
I don't think I've had this happen before , has anyone else?

Richard.

 

[Blackcat1]

Power Pivot creates a relationship between the tables based on the EditionID column, and draws a line between the two columns, indicating the relationship.
Create relationships in Diagram View in Power Pivot

1. In the Power Pivot window, click Diagram View. ...
2. Right-click a table diagram, and then click Create Relationship. ...
3. If the table is from a relational database, a column is preselected.

 

[dicken]

Power Pivot creates a relationship between the tables based on the EditionID column, and draws a line between the two columns, indicating the relationship.
Create relationships in Diagram View in Power Pivot

1. In the Power Pivot window, click Diagram View. ...
2. Right-click a table diagram, and then click Create Relationship. ...
3. If the table is from a relational database, a column is preselected.

Yes fair enough , your using the dialog box, I'd just dragged from dim to fact, but this was ok in diagram view, dim 1 side f many,
but wasn't recognized in calculations, so deleted and dragged the other way fact to dim and it worked fine. ?

RD

 

[GraH]

... missread this thread.

 

[Blackcat1]

Power Pivot creates a relationship between the tables based on the EditionID column, and draws a line between the two columns, indicating the relationship.
Create relationships in Diagram View in Power Pivot

1. In the Power Pivot window, click Diagram View. ...
2. Right-click a table diagram, and then click Create Relationship. ...
3. If the table is from a relational database, a column is preselected.

krnt.run

indigocard.ltd