6 Replies Latest reply: Apr 5, 2018 11:12 AM by Massimo Favaro RSS

    Count if finish date < start date

    Massimo Favaro

      Hi,

      I have a table with these two columns:
      StartDate and FinishDate.

      I'd like to create a measure that counts the number of rows that have a FinishDate < StartDate.

      I tried several measures like

      SUM({<FinishDate = {"<=$(=StartDate)"}>}             FinishDate)

      or

      SUM({<FinishDate = {"<=[StartDate]"}>}             FinishDate)

      but it doesn't seem to work.

      Can anyone please help me?
      Many thanks!