Forum Discussion

EnrichedUser's avatar
EnrichedUser
Icon for Helper III rankHelper III
5 years ago
Solved

Max Date Minus X Days

Hi,   I am hoping this is a fairly easy one and that I am missing something simple.   Goal: Evaluate up to the selected date minus 2 days.  I have two tables, one is a date table "Date" and th...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi EnrichedUser 

    Deduct 2 from the Max Date e.g.

     

    Picking Backlog =
IF(ISBLANK( [Picks Needed]),
BLANK(),
CALCULATE( [Picks Needed],
FILTER( ALLSELECTED('Date'),
'Date'[Date] <= (MAX('Date'[Date]) - 2) )))

     

    Regards

    Phil

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
5 years ago

Hi EnrichedUser 

Deduct 2 from the Max Date e.g.

 

Picking Backlog =
IF(ISBLANK( [Picks Needed]),
BLANK(),
CALCULATE( [Picks Needed],
FILTER( ALLSELECTED('Date'),
'Date'[Date] <= (MAX('Date'[Date]) - 2) )))

 

Regards

Phil

EnrichedUser's avatar
EnrichedUser
Icon for Helper III rankHelper III
5 years ago

I am sure I tried this and variations of this multiple times before posting this...

thank you