by Wyn Hopkins

This month’s challenge is about dates and times

There’s a surprising issue hidden in here too! The goals are as follows:

  • extract the time without the seconds
  • extract the year (watch out for the trap)
  • extract the number of days between the last Friday of the Year and the last day of the year

Take the challenge with our free download

Free Download

 

 

Our solution…

And some of the submissions we received…

Thanks for taking the challenge! Don’t miss an update and the latest in Power Query and Power BI by following us on our YouTube Channel