Forum Discussion
Newbie needs Help with aging
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 ...
Thanks Everyone I have figured out a solution to this issue
Anonymous
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 🙂