Building a DAX Time Intelligence Inspector
Creating and troubleshooting time intelligence measures in Power BI can be tricky work. Getting a measure to work at one granularity is hard enough, but when you start to look
Transform siloed data into actionable intelligence. Skypoint’s AI Platform accelerates data-centric AI initiatives for healthcare, so you see results in weeks, not months.
Quickly access quality data, business intelligence, analytics, and automation through Skypoint’s healthcare industry-tailored platform infrastructure.
Our HITRUST r2 Certified AI Platform for the healthcare industry helps you unify your data, uncover insights, and optimize productivity.
Connect with Skypoint at healthcare events, read our customer stories, and catch up on the latest AI developments on our blog.
Our team of AI and BI experts helps healthcare organizations solve operational inefficiencies and enhance productivity through unified data and industry-specific compound AI systems.
Stay up-to-date with the latest customer data news, expert guidance, and resources.
Creating and troubleshooting time intelligence measures in Power BI can be tricky work. Getting a measure to work at one granularity is hard enough, but when you start to look
A generally best practice in Power BI is to avoid naming columns in ways that won’t make sense to users so things like CustomerFirstName should be broken out with spaces
Getting a percent of total measure working in DAX, understanding how it’s working in a non vague way can be quite a bit trickier. Really it is an ideal pattern
When learning DAX, time intelligence formulas are an excellent place to start, and of the many formula patterns out there, “Year to Date” variations might be the best to learn
Custom columns are often the lifeblood of any M queries that you build. They give you huge amounts of power but by default remain untyped. You could add a step
You’ve built a simple “Sum for All Categories” measure that is so darn simple that it’s impossible for it not to work; but alas it does not. If the category
If you’ve got a large number of columns on a table to transform it can be quite a hassle. Here we’ll show a way to use List. Transform along with
Understanding Context Transition can be super frustrating for a new Power BI user. Definitions for it seem deceptively simple, but wrapping your head around how it actually works within a
Gaining an understanding of Row and Filter Context is among the most difficult challenges facing a new DAX author. Just when you think you’ve got it, a problem arises and
Text.Trim() does an excellent job of getting rid of things like ” leading spaces” and “trailing spaces ” but unlike its’ Excel cousin it doesn’t handle “excess inner spaces” at
Industry leaders and over 6 million end users choose Skypoint as their comprehensive and compliant Modern Data Stack Platform. A Gold Certified Microsoft Partner, Skypoint Cloud turns siloed customer data into connected customer experiences.