Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DDLINE CHECKING

Newbie here,   Is there any way to get the DDLINE based on a filtered calendar table.   For example:   CALENDAR TABLE (filtered all the weekends and holidays)                   ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    You could add a new index column for the calendar table.

    Then create below formulas.

    Column = LOOKUPVALUE('CALENDAR'[Index2],'CALENDAR'[date],OUTPUT[date])+OUTPUT[duration]

Column 2 = CALCULATE(MAX('CALENDAR'[date]),FILTER(ALL('CALENDAR'),'CALENDAR'[Index2] = OUTPUT[Column]))

     

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

You could add a new index column for the calendar table.

Then create below formulas.

Column = LOOKUPVALUE('CALENDAR'[Index2],'CALENDAR'[date],OUTPUT[date])+OUTPUT[duration]

Column 2 = CALCULATE(MAX('CALENDAR'[date]),FILTER(ALL('CALENDAR'),'CALENDAR'[Index2] = OUTPUT[Column]))

 

 

Best Regards,

Jay