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
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
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
Say a customer wants a line chart with a sales line, a 3 month moving avg, a 6 month moving avg, a 12 month moving average, and a same period
If you want to understand DAX, sooner or later you’re going to have to deep dive into Table Functions. The SQL BI guys Marco Russo and Alberto Ferrari train people in Table
Industry leaders choose Skypoint as their comprehensive and compliant Modern Data Stack Platform. A Certified Microsoft Solutions Partner, Skypoint Cloud turns siloed data into connected experiences.
