Running Aging Calculation

[pbi1908]

Hi guys, i have a problem. 

In my Accounts Receivable report i have in the Allocation Table the Payment Dates, The expiry dates and the Balances of my invoices so i am able and i already calculated the Age of each invoice. 

 So i created a measure that correctly calculate the running age based on a slicer that i have inside the Date from the dimension table 'Calendar'.

My problem is that i want to create a slicer with the following values which willl be able to filter the running aging, so for example if an invoice is expires at 01/10/20 and today is 30/10/20 and my slicer has max date today i want to see this invoice under 15-30 option, but if i change my slicer to 02/10/20 i want to see it under to 0-15 option. 

If i use my measure to create a calculated column i receive a circular dependency error as is normal . 

"-15>= DUE","-15< DUE <=0","0< DUE <=15","15< DUE <=30","30< DUE <=60","60< DUE <=120","120< DUE".

Does anyone has an idea on this ?

[v-shex-msft]

Hi @pbi1908,

Any update for this? Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[foodd]

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.