9 Replies Latest reply on Jul 13, 2018 4:25 PM by Shinichiro Murakami

    How do I find the amount of days between a "range of dates" filter?

    Justin Happ

      Hello, I am trying to find the amount of dates between a "range of dates" filter.

       

       

      I have a date dimension as [Session Date], it uses a range of dates filter (e.g.  6/19/2018 - 7/13/2018).

       

      Is there some LOD calculation that can give me the amount of days between these two filtered dates? And if so, will it be updated as the filter is changed?


      For example, the answer I am looking for would result in the amount of days between 6/19/2018 - 7/13/2018 to be 24 days.

       

      All assistance is appreciated, and I thank you in advance.

       

      Justin