Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Adding working days

Hello,   I am trying to add working days to a date if certain conditions are respected to create a target date. I have tried many things from the internet but nothing works and i'm more lost now th...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi amitchandak ,

 

thank you for your answer. I don't understand everything. I Think I have done that. I have this:

The problem is that I want to add the 7 working days to another date column in a another request. 

That second part, I don't get?:

Plus 10 Days = var _max =maxx(ALLSELECTED('Date'),'Date'[Work Date cont Rank])
return
CALCULATE(Min('Date'[Date]),filter(ALL('Date'),'Date'[Work Date  Rank] =_max+10))

Rolling Last 10 Days =  CALCULATE(SUM(Sales[Net Sales]),FILTER(all('Date'),'Date'[Work Date cont Rank]>=min('Date'[Work Date cont Rank])-10 
				&& 'Date'[Work Date cont Rank]<=max('Date'[Work Date cont Rank])))