Category: DAX
-
Evaluation Context and Calculating Sales Margins
Excel to #PowerBI Part 3 – Getting Started with #DAX: SUMX and CALCULATE
-
Excel to Power BI Connected Data
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!
-
Power BI Learning Resources
Some of the best #PowerBI #DAX learning resources online! Thanks to Alex @itsnotaboutthecell for contributing!
-
Learning from the Power BI Community – Top 10
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, culture, and the list goes on. All great resources, and a clear […]
-
Improve the Readability of the Matrix Visual.
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 transaction detail makes it a fast friend of any Accountant or Financial […]
-
Moving average chart using dynamic measures and custom time intelligence
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 provide a dynamic moving average chart that allows the user to determine […]
-
Filter a measure with a slicer??
I gotta share something I saw from v-jiascu-msft on the community forum. I have an original measure that evaluates total sales over $50 as high, and under as low. I then write the below measure that references a disconnected table. Last step […]
