Forum Discussion

alcakdata's avatar
alcakdata
Frequent Visitor
3 years ago

AR aging report with dynamic date selection

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 & payments in a single table, and my invoices ...
Need Help
Mahesh0016's avatar
Mahesh0016
Super User
3 years ago

alcakdata 
Create Measure :

30-60 =
VAR SelectedDate = max(slicer[date])

RETURN
calculate (
                 [Total Sales],
                 filter(
                           Allselected(entry dates),
                           datediff( entry dates,SelectedDate ,60)<61
                           &&

                           datediff( entry dates,SelectedDate ,30)>=30

                        )

             )

alcakdata I hope this helps you!THANK YOU!!