Skillwave Training @skillwave.training · 3d In our last AKA session, one of our students asked for help with a tricky format. Data was arriving in ISO week codes — a four-digit year paired with a two-digit week number — and needed to become an actual working calendar for reporting. 📅 ISO weeks follow a strict international standard...🧵
0 likes 1 replies
?
Replies
@excelguru.ca built a quick custom #PowerQuery function that unpacks any ISO week into real calendar dates. He then expanded the calendar to add other key periods for dimensional reporting. 💪 It turned a rigid international standard into something flexible enough to actually report on.