Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi super users, can you help a novice with this query please?
I've created a custom column to show when our next training refresher is due. This is using the last booking date and adding the refresher cycle no. of years. However, some of the rows show the training is yet to be booked "TB", this is creating errors in my new customer column. I'd like the TB to appear in the custom column where no date is available, ie the error cells. Can you tell me what I need to add to the syntax to achieve this please. I've tried allsorts but being fairly new to PBI I could do with some pro help please? Sure this will be obvious to most. Thanks in advance.
Solved! Go to Solution.
Hello - here is how you can do this.
SCRIPT
Table.AddColumn(#"Replaced Value2", "Next refresher due", each if [Booking status] = "TB" then "TB" else Date.AddYears ( Date.From ( [Booking status] ), [Refresher cycle in years] ), type text )
RESULT
Hello - here is how you can do this.
SCRIPT
Table.AddColumn(#"Replaced Value2", "Next refresher due", each if [Booking status] = "TB" then "TB" else Date.AddYears ( Date.From ( [Booking status] ), [Refresher cycle in years] ), type text )
RESULT
Thanks for the swift reply, I'm just trying it out now.