AR aging report with dynamic date selection

Question

Hello!I need to prepare an AR aging report based on brackets (30-60, 60-90 etc), dynamically for a selected date. I have entry dates for all the sales &amp; payments in a single table, and my invoices don't have due dates (=their due dates are 0). Customers may make partial payments as well. I am attaching an example of my dataset below.&nbsp;&nbsp;The final result should be; for a selected date, remaining balance in day brackets. Appreciate any help on this!&nbsp;

mahesh0016 · Answer

alcakdata&nbsp;Create Measure :30-60 =VAR SelectedDate = max(slicer[date])RETURNcalculate (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;[Total Sales],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;filter(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Allselected(entry dates),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;datediff(&nbsp;entry dates,SelectedDate ,60)&lt;61&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;datediff(&nbsp;entry dates,SelectedDate ,30)&gt;=30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;)alcakdata&nbsp;I hope this helps you!THANK YOU!!

Forum Discussion

AR aging report with dynamic date selection

1 Reply

Related content

Dynamic Filter with Dynamic Measure Selection in Report Matrix

Dynamic images based on selections

Dynamic Filtering based on date selection

Dynamic Cards by Selection on a Chart

Dynamic Report Subscription