Forum Discussion
Getting Current, 30, 60, 90 Day AR Aging
I have an Accounts Receivable table called "AR" that has a Date column and a Transaction Amount column. I have your standard "Date" table. The two tables are related via the Date Columns. I want t...
Hi Anonymous ,
It works fine on my pbix I tested.
Sample data
Table AR:
Relationship:
The slicer is created by the date field from Date table.
You can check more details from the attachment.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
It works fine on my pbix I tested.
Sample data
Table AR:
Relationship:
The slicer is created by the date field from Date table.
You can check more details from the attachment.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.