topic Re: Receivables aging in DAX Commands and Tips

Receivables aging

Anonymous — Mon, 12 Dec 2022 20:14:03 GMT

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 between the due date and selected date on the slicer. Already looked into the formus here but didn't exactly find what I need. If this has already been answered, please point me to the solution.

Customer Code	Invoice	Amount	Due Date
PS-CR-1305	INV00023	2,868	5/14/2023
PS-CR-0238	INV00024	14,065	2/15/2023
PS-CR-0238	INV00025	7,444	1/2/2023
PS-CR-1220	INV00026	8,066	12/29/2022
PS-CR-0519	INV00027	4,871	12/29/2022
PS-CR-0791	INV00028	1,686	12/23/2022
PS-CR-0519	INV00030	7,782	12/22/2022

Thanks

Re: Receivables aging

Anonymous — Tue, 13 Dec 2022 02:55:24 GMT

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

Re: Receivables aging

Anonymous — Tue, 13 Dec 2022 15:45:59 GMT

Thi worked, Thanks