Using Variables for Clean and Efficient DAX
This article will transform how you write DAX. By the end, you will understand not just the syntax of variables, but the patterns and practices that separate average DAX from truly professional code.
This article will transform how you write DAX. By the end, you will understand not just the syntax of variables, but the patterns and practices that separate average DAX from truly professional code.
CALCULATE is the most important function in DAX.
If you truly understand CALCULATE, you understand how Power BI thinks.
It allows you to control filters, override slicers, ignore visuals, and apply business rules correctly. Almost every advanced Power BI measure relies on CALCULATE in one way or another.
In this article, we will explore CALCULATE in depth and clearly explain how filter modification works using:
• ALL
• ALLEXCEPT
• REMOVEFILTERS
• KEEPFILTERS
Overdue payments are one of the most pressing financial challenges organizations face. When invoices sit unpaid beyond their due date, cash flow suffers, and without visibility into how long payments have been outstanding, finance teams are left guessing. Power BI offers a powerful way to build an aging dashboard that not only tracks overdue payments but also highlights the severity and risk associated with each one.
Restoring a database is a fundamental task for SQL Server administrators and developers. Whether you're setting up a development environment, recovering from data loss, or migrating data between servers, understanding the restore process is essential. In this guide, we'll walk through restoring the AdventureWorks database, a popular sample database from Microsoft.
If you’ve ever built a model-driven app in Power Apps, you’ve probably battled with slow-loading command bar buttons. You click a table, and for 3… 5… sometimes 10 seconds, your button just refuses to appear.
For ages, I kept asking:
Why are my buttons taking so long to show up, even when my formula is simple?
This blog is the answer I wish I had earlier, and the pattern that finally solved the performance problem completely.
In today’s fast-paced business world, effective governance isn’t just a requirement it’s a competitive advantage. Boards are expected to make faster, data-driven decisions while maintaining high levels of transparency, collaboration, and security. Yet many organizations still rely on scattered documents, endless email threads, and manual preparation that slow down the entire process.
This month, Sibasi turns eight. In the fast-moving world of technology, eight years is not just a number it’s proof of resilience, relevance, and the ability to grow alongside the communities we serve.
I joined Sibasi three months ago, and walking into an organization with nearly a decade of history is both inspiring and humbling. From my first days, I could feel that Sibasi isn’t just a tech company it’s a partner to nonprofits, Educational Institutions and businesses across Africa.
When building apps in PowerApps, it’s tempting to store only the name of an item (like Access Item Name) instead of its unique ID. It works at first, but quickly creates long-term problems:
Last week, I had the privilege of serving as one of the Lead Trainers in a week-long Power BI Masterclass. The primary goal of this training was to help learners gain a clear understanding of the full Power BI ecosystem, explore how it can make a tangible impact in their organizations, and equip them with the practical skills required to implement what they learned.
On 24th and 25th July 2025, we attended DynamicsCon Regional: East Africa 2025, and it was an incredibly energizing and insightful experience.
We were privileged to take the stage where we talked about the integration between Microsoft Dynamics 365 and Power BI. Our session focused on demonstrating just how powerful these platforms can be when used together. Rather than just talking about it, we brought it to life with a live showcase.
We explored;
The digital marketing world is undergoing a revolution—and AI is both the catalyst and the disruptor. From personalized recommendations to predictive analytics, AI isn’t just helping marketers work better. It’s redefining the rules of the game.
Discover how artificial intelligence is disrupting digital marketing—from automating content creation to challenging brand authenticity—and what marketers must do to adapt.
When working with SharePoint and Microsoft 365, small tweaks can make a huge difference — especially when it comes to URLs