cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mk720x Regular Visitor
Regular Visitor

Multiple Relationships from same table connecting to Date Table

This is likely very intuitive and been answered before but I couldn't seem to find it.

I have data that contains a unique ID for the project and lots of milestone completion dates.

EX:
ID1 has milestone 1, milestone 2, milestone 3, etc. etc.

 

I want to graph the number of completions of each milestone per month, but am having issues.
I created a date table and created a relationship with (let's say) milestone 1. It only allows 2 relationships, so I can't correctly link all of the milestones to the date table.

I read somewhere to use the USERRELATIONSHIP measure but it threw an error because the columns aren't calculated (?)

 

Help appreciated!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Multiple Relationships from same table connecting to Date Table

Hi @mk720x,

You can create several relationships between 2 tables however only 1 will be active the rest will be inactive and you have to use USER RELATIONSHIP to make use of them.

On yor case let's assume you have the link between date and milestone 1 active and with milestone 2 inactive you need to had the following measures

COUNT OF MILESTONE 1 = COUNT(Table[Column])
COUNT OF MILESTONE 2 = CALCULATE( COUNT(Table[Column]); USERELATIONSHIP(calendar[date] ; Table[Milestone 2 Date] ))

The use the date on calendar table on your visuals and the measures on values

Regards,
MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




3 REPLIES 3
Super User
Super User

Re: Multiple Relationships from same table connecting to Date Table

Hi @mk720x,

You can create several relationships between 2 tables however only 1 will be active the rest will be inactive and you have to use USER RELATIONSHIP to make use of them.

On yor case let's assume you have the link between date and milestone 1 active and with milestone 2 inactive you need to had the following measures

COUNT OF MILESTONE 1 = COUNT(Table[Column])
COUNT OF MILESTONE 2 = CALCULATE( COUNT(Table[Column]); USERELATIONSHIP(calendar[date] ; Table[Milestone 2 Date] ))

The use the date on calendar table on your visuals and the measures on values

Regards,
MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




mk720x Regular Visitor
Regular Visitor

Re: Multiple Relationships from same table connecting to Date Table

Thank you! Some things to add in case anyone else reads this post:

You have to change the semi colons to commas and USERELATIONSHIP has one r.

 

 

COUNT OF MILESTONE 1 = COUNT(Table[Column])
COUNT OF MILESTONE 2 = CALCULATE( COUNT(Table[Column]), USERELATIONSHIP(calendar[date] , Table[Milestone 2 Date] ))

Super User
Super User

Re: Multiple Relationships from same table connecting to Date Table

Hi @mk720x ,

 

Thank you for the correction on the formula my error when posting Smiley Happy

 

Regading the Comma part for your information that as to do with regional settings and some are with dot comma others with comma.

 

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!