Forum Discussion

kjrudy14's avatar
kjrudy14
Frequent Visitor
4 years ago

Dynamic Date in AR Aging Report

Hello,   I am currently working on an AR Aging report in Power BI.  I have the report completed, however, I am unable to make the aging buckets dynamic with a date selector.    The data is only as ...
Need Help
faisalazh's avatar
faisalazh
Advocate II
4 years ago

I think you have to create a summary table to cross join your calendar and aging group. then create column to summarize the amounts then create relationship between new summary table with calendar.

1. cross join your calendar with aging group you can do formula like:

Summary AR = CrossJoin('CalendarTable', 'Aging Group Table')

2. Create in New Summary AR table a calculated columns. eg. Age 1-30, etc.

3. Create relationship 'Summary AR' table with 'CalendarTable'.

hope this help.