Creating custom subtotals in the matrix visual.
Some of the best #PowerBI #DAX learning resources online! Thanks to Alex @itsnotaboutthecell for contributing!
I quickly put Business Intelligence to work providing users access to insights and trends. Reducing manual work and giving others 24/7 access to analysis was no doubt a win for … Continue Reading Unlocking the potential of data storytelling
Welcome to Story BI!
Two hours of SQLBI and Guy in a Cube!
5 Tips that help turn data into direction.
As a distributor, we offer a ‘spend and profitability’ report in Power BI as an added value for our customers. This report serves two purposes: 1. To provide the customer … Continue Reading Using TREATAS to improve profitability reporting
Excel to Power BI Part 3 – Getting Started with DAX: Concepts and Examples
Excel to #PowerBI Part 3 – Getting Started with #DAX: SUMX and CALCULATE
This step-by-step blog series covers just enough to get you rolling. Find out how Power BI compliments what you already know and love in Excel!
If you are an #MSExcel user looking for a 20 minute hands-on demo that will get you started in #PowerBI, check out part 1 of my new blog series “Excel to Power BI”!
2020 has been a great year to dive deeper in Power BI and new emerging features and tools. I’ve enjoyed learning from reporting tips, external tools, updated books, more M, … Continue Reading Learning from the Power BI Community – Top 10
Need to clean up the specific key words within a column of text strings? Check this out!
It’s no surprise that a program aimed at the pivot table loving business user would include a similar visual called the Matrix. The ability to summarize, search, and drill into … Continue Reading Improve the Readability of the Matrix Visual.
Create a visual and interactive Income Statement using Power BI
I see this question pop up periodically, I thought I’d update the blog with an older LinkedIn post I shared two months ago. In this post I share the M … Continue Reading M + DAX = Dynamic report date & time stamp.
Line charts in Power BI provide a way to help supplement a sales table with useful trend information. In this post, I’d like to take this a step further, and … Continue Reading Moving average chart using dynamic measures and custom time intelligence