Newbie needs Help with aging

[jnaugle]

Hello my name is Jamie. I am pretty new to power bi and data modeling in general. I would like to have a dax formula that will look at a colum name remaining balance, if the colum has data then sort it in one of three colums 30,60,90. That way I can see if a client has a balance and how far past due it is.

Thanks in advance for any help you can give.

Jamie

[Anonymous]

Hi @jnaugle ,

Could you please provide some sample data(exclude sensitive data) and your expected result? What 30, 60 and 90 means? They are the duration between xxDate and current date?

Best Regards

Rena

[jnaugle · Accepted solution]

Thanks Everyone I have figured out a solution to this issue

[Anonymous]

Hi @jnaugle ,

Glad to hear that you have gotten the solution for your problem. Could you please marked it as answered since the problem has been solved?

Best Regards

Rena

[nandukrishnavs]

@jnaugle 

Assume your table is similar to below.

Company	Sales	Date
A	100	01-04-2020
B	150	01-03-2020
C	200	01-02-2020
D	250	01-01-2020
E	300	01-12-2019

Create a calculated column

Aging = 
var _days=DATEDIFF(TableSale[Date],TODAY(),DAY)
var _result= IF(_days<=30,"30",IF(_days<=60,"60","90"))
return _result

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂