Don’t just watch the course lessons and hope you “get it.” Our #SelfServiceBI (skw-t.com/ssbi) and #Excel Fundamentals (skw-t.com/excelfun) Academies come with access to AKA sessions where we guide you through applying what you’ve learned.

#PowerBI #DataAnalytics #BusinessIntelligence

Ken's fix? Just delete the hardcoded column count argument in the formula bar and 💥boom, all columns load again! It was equal parts relief and frustration for everyone watching. 😅

🧭 Takeaway: Check for hidden hardcoded parameters - sometimes Power Query sets you up for failure!

Stuck trying to apply what you’ve learned to your own data? With our #Excel Fundamentals (skw-t.com/excelfun) and #SelfServiceBI (skw-t.com/ssbi) Academies, you don’t have to go it alone. Bring your questions to our instructor-led AKA sessions and get unstuck, fast.

It was one of those classic “Aha!” 💡 moments - turning a messy logic question into a clean model design with a simple DAX formula:
=CALCUALTE( [Sales $], Product[Commissionable] = "Yes" )

🧭 Takeaway: When in doubt, model it out. Adding a simple column can save hours of DAX headaches later!

We almost put a sad face emoji in the original reply, but then thought that might send mixed messages. 😜

Agreed, this is really stupid.

Hahahaha, classic!

Learning is great - applying it is even better. Enroll in our #SelfServiceBI (skw-t.com/ssbi) or Excel Fundamentals (skw-t.com/excelfun) Academies, or the AKA sessions on their own (skw-t.com/aka), to get help applying what your learned to your real-world scenarios.

...month-to-month comparisons across years, fiscal calendars, 4-4-5 periods, and how the end users’ experience could change depending on which control you provided.

🧭 Takeaway: Understanding the subtle differences between slicers and timelines changes how your audience explores a #PivotTable.

Ken explained that timelines force users to select contiguous date ranges – perfect for financial or sales reporting – while slicers permit non-contiguous selections (like January and March only). The group loved seeing both options demo’d live, sparking side discussions about...