Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Over Due Items Based on Due Date

I have one table, in that table I have a due date column. I would like to show the amount of items over due. 

 

Maybe, If the due date is before now? Thanks in advance.

Need Help
  • FreemanZ's avatar
    FreemanZ
    2 years ago

    hi Anonymous ,

     

    try like:

    measure =
    CALCULATE(
        SUM(data[amount]),
        data[due date]<=TODAY()
    )

1 Reply

  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    2 years ago

    hi Anonymous ,

     

    try like:

    measure =
    CALCULATE(
        SUM(data[amount]),
        data[due date]<=TODAY()
    )