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