Forum Discussion

voidbydefault's avatar
voidbydefault
Icon for Helper I rankHelper I
1 year ago
Solved

Calculating receivable aging dynamically

Hi,   I want to calculate "aged balances" dynamically in a way that dashboard users have two options to change the overdue days being overdue days as option 1) [Invoice Due Date] and TODAY(); and 2...
Need Help
voidbydefault's avatar
voidbydefault
Icon for Helper I rankHelper I
1 year ago

First, thanks to johnt75 , ajohnso2 , and Anonymous for your time in trying to help. In my unique case, I realized I need to calculate invoice aging at row level so I added four columns in my data table as:

 

 

Then created a parameter with its slicer:

test_OS_Days = {
    ("xDays Outstanding from Report Date", NAMEOF('data_006_custBal'[xAging Bucket Report Days]), 0),
    ("xDays Outstanding from Today", NAMEOF('data_006_custBal'[xAging Bucket Today Days]), 1)
}
 
This enabled the functionality I was aiming to achieve.