Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Receivables aging

Hi,   Below is a sample table for customer invoices. I have a calender table and would like to see the aging as of date using a slicer. Calculation of the buckets will be using the difference betwe...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi  Anonymous ,

     

    Here are the steps you can follow：

    1. Create measure.

    Measure =
var _select=SELECTEDVALUE('calender table'[Date])
return
DATEDIFF(_select,MAX('Table'[Due Date]),DAY)

    2. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi  Anonymous ,

 

Here are the steps you can follow：

1. Create measure.

Measure =
var _select=SELECTEDVALUE('calender table'[Date])
return
DATEDIFF(_select,MAX('Table'[Due Date]),DAY)

2. Result:

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thi worked, Thanks