How to Navigate Hierarchies with ISINSCOPE & SORTBY
Brian Grant
January 23, 2019
BRIAN GRANT (Skypoint CSG)
Menu
Stay up-to-date with the latest data and AI news, expert guidance, and resources.
BRIAN GRANT (Skypoint CSG)
JEREMY BLACK & KIRILL PERIAN (Data Driven Solutions) Creating a multi-language reporting solution in Power BI presents a number of challenges along the way. Our team would like to
RACHEL DYER (Skypoint CSG) Rachel Dyer is the Vice President of Analytics at Skypoint CSG with in-depth expertise of the Microsoft BI stack and dimensional modeling. She has a
TED PATTISON (Critical Path Training) In this user group talk, Ted Pattison will deliver a fast-paced primer on the fundamentals of the M programming language. This session aims to
RON BARRETT (Audigy Group) Oracy is the ability to express oneself fluently and grammatically in speech. Literacy is the ability to read, write. Numeracy the ability to understand and
BRIAN GRANT (Skypoint CSG) In this presentation local DAX obsessive Brian Grant will show you how to use a CSG built Dial sparkline measure to quickly display goal to
If the goal is an actual comparison, it’s hard to beat the bullet chart. Highly efficient in terms of the amount of space they take up, with excellent data to
Sparklines and small multiples are incredibly powerful. They allow you to add a tiny simple graph to a table or a matrix that conveys the basic idea or shape of
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
