Posts filed under DAX

(Livestream Replay) Elements of DAX - With Brian Grant

Join us as Brian will be talking about his "Elements of DAX", which is both a YouTube video series as well as an underlying conceptual framework aimed at making learning DAX simpler by breaking all of its main functions down into just three simple categories. Allegedly, once you learn these you can put them together like Legos to solve common DAX problems. He likes to teach visually, so don't be surprised if some demos pop up in the conversation.

GUEST BIO 📄

Hailing from the East side of beautiful Portland OR, Brian is a Senior Business Analytics consultant with local data heroes CSG Pro. Having spent his early years deep in the study of acting and screenwriting, he finally graduated Summa Cum Laude with a degree in Economics. His driving belief is that the biggest barrier most people face when learning technology isn't technology at all, but language. Taught the right way, most people can learn most things; helping people learn skills that are "too technical" for them is his greatest joy.

RELATED CONTENT 🔗

Elements of DAX Video Series
CSGPro YouTube
Brian’s Twitter
Brian’s LinkedIn

Posted on April 30, 2021 and filed under DAX, Livestreams, Beginner.

Conditionally Formatting Positive & Negative Line Chart Colors in Power BI

Video by: Reid Havens

Learn how to enhance the line and area chart visuals in Power BI by conditionally formatting the positive and negative line chart colors.

RELATED CONTENT 🔗

Adding KPI Indicators to Native Line Charts in Power BI

Posted on April 27, 2021 and filed under Power BI, Beginner, DAX, Visualizations.

Fiscal Periods Time Intelligence Slicer in Power BI

Video by: Reid Havens

Part four of four in a series - learn how to leverage relationships and DAX calculated tables to create a time intelligence slicer with fiscal periods in Power BI. The end result will perform faster and create a better user experience versus needing to create many time intelligence DAX measures.

RELATED CONTENT 🔗

Part 1: Creating MTD/QTD/YTD Filters
Part 2: Applying USERELATIONSHIP Function
Part 3: Additional Date Periods

Posted on March 30, 2021 and filed under DAX, Power BI, Slicers & Filters, Intermediate.