Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Days Remaining Calculation

I am looking for some help calculating days remaining.  

 

That is to say that I have a specific field which identifies an "end date", and I am looking to calculate how many days between today and the "end date".  I found similarly asked questions but not of the solutions for those specific concerns were applicable.

 

Would appreciate any help.

 

Thanks in advance.

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    9 years ago

    Awesome.  Actually needed a MIN not MAX, as I was trying to get a day count between today and end date.  If end date is after today then 0.

     

    = MIN ( 1 * ( Today ( ) - YourTable[EndDate] ) , 0)

     

    Thanks - this was extremely helpful!

  • Datatouille's avatar
    Datatouille
    9 years ago

    Anonymous

     

    If [End Date] > Today ( ) Then 0 Else 1 * ( Today ( ) - YourTable[EndDate] ) is equivalent to

     

    MAX ( 1 * ( Today ( ) - YourTable[EndDate] ) , 0)

     or

    - MIN ( 1 * (  YourTable[EndDate] - Today ( )  ) , 0 )

     

    But not to:

    MIN ( 1 * ( Today ( ) - YourTable[EndDate] ) , 0)

11 Replies

  • Datatouille's avatar
    Datatouille
    Solution Sage
    9 years ago

    Hi Anonymous

     

    Do you wish to perform this calculation in a measure or a calculated column ?

    You can use DateDiff Function to calculate the number of days between Today and your EndDate.

     

    In a calc. Column:

    DateDiff ( YourTable[EndDate] , Today() , DAY)

     

    In a measure, you'll need to wrap your 1st argument into an aggregator such as Min or Max in this case.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      I believe I need it as a column.  Following your instructions I receive an error:

       

      Too few arguments were passed to the RELATED funtion.  The minimum argument count for the functions is 1.

       

      Not sure what this means.

      • Datatouille's avatar
        Datatouille
        Solution Sage
        9 years ago

        Anonymous

         

        Why are you using Related function here ? Haven't mentioned it in my reply.