Author: Mark Walter
-
Using TREATAS to improve profitability reporting
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 with a daily tracker of purchases made during the month. 2. To […]
-
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 Query Basics
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”!
-
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 […]
-
Replacing field values based on partial strings in Power Query.
Need to clean up the specific key words within a column of text strings? Check this out!
-
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 […]
-
Creating an Income Statement in Power BI
Create a visual and interactive Income Statement using Power BI
-
Create a date timestamp in 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 and DAX work around that has done the trick to get a […]