Forum Discussion
Creating an Aging Bucket
Hello all, I am new to PowerBI and am looking to create an AR Aging bucket. I have pulled all the relevant information from our SQL server, but cannot figure out how to create calculate columns b...
Anonymous what is your definition for "age"? If it is net_due_date - invoice_date, then a calculated columns something like below might work:
Age_Bucket = VAR _Age = DATEDIFF('Table'[invoice_date],'Table'[net_due_Date], DAY) VAR _Result = SWITCH( TRUE(), _Age < 30, "0-30 days", _Age >= 30 && _Age < 60, "30-60 days", _Age >= 60 && _Age < 90, "60-90 days", _Age >= 90, "90+ days" ) Return _Result
Anonymous what is your definition for "age"? If it is net_due_date - invoice_date, then a calculated columns something like below might work:
Age_Bucket =
VAR _Age = DATEDIFF('Table'[invoice_date],'Table'[net_due_Date], DAY)
VAR _Result =
SWITCH(
TRUE(),
_Age < 30, "0-30 days",
_Age >= 30 && _Age < 60, "30-60 days",
_Age >= 60 && _Age < 90, "60-90 days",
_Age >= 90, "90+ days"
)
Return
_Result