Adding Amount into appropriate Aging Bucket Columns

[hari_sreen123]

Greetings,

I have already created a column that has Age. I want to create columns like '1 - 30', '30 - 60' and add the amount based on the Days past (Age). I'm not sure if I should use Custom columns, Conditional columns, or DAX functions. Any help would be greatly appreciated. 

The third and fifth rows are good examples of what I want to do. Thank you! 

[HashamNiaz · Accepted solution]

Hi @hari_sreen123 !

You can create 4 new columns using following DAX code;

1 - 30 = IF(Table[Age] >= 1  && Table[Age] <= 30, Table[Amount], 0)

31 - 60 = IF(Table[Age] >= 31  && Table[Age] <= 60, Table[Amount], 0)

61 - 90 = IF(Table[Age] >= 61  && Table[Age] <= 90, Table[Amount], 0)

91 - 120 = IF(Table[Age] >= 91  && Table[Age] <= 120, Table[Amount], 0)

 You can replace Table with your table name, [Age] is the column which you used for calculating Days past, and [Amount] is a column which you want to assign.

Regards,

Hasham