Use Debtors Age Bracket as Measure for Axis - Debtors Age analysis

[armandvdm]

I really need some clever inspiration.

I create a debtors age analysis dynamically for the selected month-end date.

The two important date measures are 1) Age in days and age bracket which uses age in days.

Age in days

Age =

var selecteddate =

CALCULATE ( MAX( MonthEndDates[myDate] ), ALLSELECTED ( MonthEndDates ) )

var myage =

DATEDIFF(max(Episode[DischargeDate]),selecteddate,DAY)

return IF(myage <0, -1,MYAGE)

and Age bracket

AgeBracket = if([Age] <0, "Current",

if([Age] <= 30, "Current",

IF([Age] <= 60, "30",

IF([Age]<=90 , "60",

IF([Age] <= 120, "90",

"120+"

)))))

I want to use Age Bracket as Axis for Graph. As it is a measure I cannot use it.

I thought about the workaround using a calculated table and convert the AGE and AgeBracket measures to calculated columns, but as the selection date is dynamic, I cannot access the SELECTEDVALUE or ALLSELECTED slicer value in a column to calculate the date difference between the selected date and discharge date.

Hope I explain it correctly. 

Regards

Armand

[kcantor]

@armandvdm 

Have you tried Binning the ages?

https://docs.microsoft.com/en-us/power-bi/desktop-grouping-and-binning

[armandvdm]

Thanks, it appears as if PowerBI does not allow binning on a measure column.

Regards

Armand