Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Bartolo88
New Member

BI report on training/competency expiration

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

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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"

)

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@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"

)

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.