Forum Discussion
Adding working days
Hi Anonymous
Relationships will propagate filters between tables so it is not allowed to have multiple active relationships between tables to avoid ambiguity. If you are not familiar with active/inactive relationships, you can refer to this guide: Active vs inactive relationship guidance
In addition, the RELATED function requires that an active relationship exists between the current table and the table with related information. If you want to get the +7 working date according to Relance 2 or Relance 3, you can try below code. This code is not dependent on the relationship.
Column 2 = MAXX ( FILTER ( ALL ( 'Calendar' ), 'Calendar'[Date] = EARLIER ( 'Tracking (2)'[RELANCE 2] ) ), 'Calendar'[+ 7 Working Days] )If this is not what you want, can you please show what you want to do with Relance 2 and Relance 3?
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hello v-jingzhang ,
Thank you so much! It works!!! Now the only problem I have is that I want to that with 2 different columns in the same query: Relance 2 and Relance 3
But when I try to create a relation between Dates from the query Calendrier and Relance 2 and Relance 3 from tracking query it says I can't create 2 relations. Would you know how I can fix that?
Community SupportHi Anonymous
Relationships will propagate filters between tables so it is not allowed to have multiple active relationships between tables to avoid ambiguity. If you are not familiar with active/inactive relationships, you can refer to this guide: Active vs inactive relationship guidance
In addition, the RELATED function requires that an active relationship exists between the current table and the table with related information. If you want to get the +7 working date according to Relance 2 or Relance 3, you can try below code. This code is not dependent on the relationship.
Column 2 =
MAXX (
FILTER (
ALL ( 'Calendar' ),
'Calendar'[Date] = EARLIER ( 'Tracking (2)'[RELANCE 2] )
),
'Calendar'[+ 7 Working Days]
)
If this is not what you want, can you please show what you want to do with Relance 2 and Relance 3?
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Thank you so much v-jingzhang !!!!! It's exactly what I wanted and it works !!!!