Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Aging Days Overdue Calculated Column

Hi All,   can you please help me with this issue I have? Currently, I have two tables, one for date and another for customer transactions. And I want to have a column where it will show the age of ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , if you want to calculate age against max date or today you can have column

     

    Age = Datediff([Due date], today(), day)

     

    Using switch , you can create a bucket -new column -https://www.youtube.com/watch?v=gelJWktlR80

     

    But it is based on the selected date, then you need to measure

     

    Age = Datediff([Due date], selectedvalue(Date[Date]) , day)

     

    In this case, you need to create a bucket using an independent table - https://www.youtube.com/watch?v=CuczXPj0N-k

     

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , if you want to calculate age against max date or today you can have column

 

Age = Datediff([Due date], today(), day)

 

Using switch , you can create a bucket -new column -https://www.youtube.com/watch?v=gelJWktlR80

 

But it is based on the selected date, then you need to measure

 

Age = Datediff([Due date], selectedvalue(Date[Date]) , day)

 

In this case, you need to create a bucket using an independent table - https://www.youtube.com/watch?v=CuczXPj0N-k