0 Replies Latest reply: Jun 7, 2018 9:35 AM by Juraj Pavol RSS

    Count within Date interval

    Juraj Pavol

      Hi all,

       

      I try to solve following problem but with no success.

       

      I have data in following structure

       

      Item nameActivation dateExpiration date
      Blue01/201803/2018
      Gree01/201805/2018
      Red02/201805/2018
      Pink03/201806/2018
      Black04/201806/2018

       

      On the sheet I have Data picker where I can select date in format eg. 04/2018 = Select month

       

      1. I need count all records where Activation date <=Select month <= Expiration date

       

      I try this but it not works:

      Count(distinct{$<[Select month]={">=[Activation date]<=[Expiration date]"}>}[Item name])

       

      2. I need count all records where Activation date <=Select month <= Expiration date

      and also if Expiration date is NULL it will be counted to total count


      Please could you help me.

      Thanks in advance.