Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Flag column all dates based on two dates

Hi All,   In the flag column I would like to see 1 (or true / false) if the date is between the start and enddate. The startdate is based on the Quantity column, if the quantity is larger then 12, ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

Anonymous Try:

flag column =
  VAR __Date = [Date]
  VAR __Start = MAXX(FILTER('Table',[Quantity]>12 && [Date]<=__Date),[Date_start])
  VAR __End = MAXX(FILTER('Table',[Quantity]>12 && [Date]<=__Date),[Date_end])
RETURN
  IF(__Date <= __End && __Date >= __Start),1,BLANK())
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Greg,

    Thanks for the quick reply. The flags in green are correct, but the red ones are not. Can't figure out why they are flagged..