Author: Mark Walter
-
Data storytelling in Power BI
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 our business. However, it took time to realize that this approach of […]
-
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 […]
-
Power BI Calendar Table in Excel
Tracks Calendar and Fiscal years by day, as well as custom holidays and workdays. I am sharing a custom time intelligence Calendar Table in Excel that I built for our custom calendars needs. It considers calendar and fiscal year, as well as […]
-
The Man Who Wrote His Own Obituary “Cigarettes were the death of me”
Re-printed from Reader’s Digest – July 1966 Mark Waters, long time reporter for the Honolulu Star-Bulletin, started his last story January 27. “Run it as my obituary,” he said on that day. “Maybe it will help someone.” Four days later he made […]