Forum Discussion
Adding Amount into appropriate Aging Bucket Columns
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!
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
1 Reply
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