BI report on training/competency expiration

[Bartolo88]

G'day everyone,

I have a simple data set for my team's competencies and training. Each column (there are over 12) refers to a training and competency. Each row refers to each team member. Values are formatted dates that stipulate when that training requires a referresher or "re-sit". Because competencies for us are really dynamic we need to make sure these dates don't slip and we know they are upcoming.

I would like to create a visualisation that informs us of the 30/60/90 day rule for when these course are up coming to plan for? Possibly as a multi row card or bar chart - however something I'll play around with when the data is locked in.

Does any one know how I should go about this considering all my dates are futures and the report will be refreshed and generated weekly?

Thanks in advance and really looking forward to the assist.

Bart

[amitchandak · Accepted solution]

@Bartolo88 , Create a bucket column like

New column =

var _diff = datediff(today(), [Plan Date], day() )

return

Switch(true() ,

_diff <= 30 , "  0 -30 Days",

_diff <= 60 , " 30 -60 Days",

_diff <= 90 , " 60 -90 Days",

"More than 90 Days"

)