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

 

 

Our solution…

And some of the submissions we received…

• Alexander Sorokopyt
• Bhavya Gupta
• Dyota Tanuwibawa
• Egor Vaulin
• Giannis Kiokpas
• Khaled Chowdhury
• Melissa Stanton
• Munir Airmarzoug
• Peter Gulstad
• Peter Tholstrup
• Quadri Atharu
• Samuel Vanderslink

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