# KnowledgeBank VLOG #1: Intros, goals and some background on what we want to do…

I decided to record a quick video on what the KnowledgeBank is, what we are trying to do and why we are doing it. No point to rehashing it here as it's a short video, hope you like what I got to say. https://youtu.be/0sL8t4hl9_E

# My Reaction to Microsoft Closing its Retail Stores

Microsoft just recently announced that it is taking a "new approach to retail". What's the new approach you ask??? Well, it is a bit unorthodox. The new approach to retail is to have no retail. This is a bit of a sad news for me as I do a lot of work with Microsoft and … Continue reading My Reaction to Microsoft Closing its Retail Stores

# Demystifying DATESINPERIOD (or How to Calculate N Months Average Excluding the Current Month)

Date functions in Power BI are not always easy. And sometimes they can be a little confusing… And sometimes, a little more than just a little.. For no other reason than pure serendipity, I have decided to record a quick video using a calculation I had to write to implement a four-month average logic that … Continue reading Demystifying DATESINPERIOD (or How to Calculate N Months Average Excluding the Current Month)

# Power BI & DAX: Making Sense of CALCULATE() and FILTER() Functions

If you get butterflies in your stomach every time you have to use CALCUATE or FILTER functions in your DAX then stick around, as I will try to give you some tools that will hopefully bring that anxiety to manageable levels. This is not a short video, unfortunately. I could not cut it short because … Continue reading Power BI & DAX: Making Sense of CALCULATE() and FILTER() Functions

# Power BI & DAX: How to Use Breadcrumbs to Fix the Fatal Flaw of the Filter Pane

in this video I talk about the fatal flaw of the Power BI's Filter pane and how we can fix it with breadcrumbs. What fatal flaw am I talking about? What the heck is a breadcrumb? Well, watch the video and you will find out. https://youtu.be/6HHbPzqhcn8 These are the measures that I have created to … Continue reading Power BI & DAX: How to Use Breadcrumbs to Fix the Fatal Flaw of the Filter Pane

# PowerBI & DAX: Three Reasons to Move All Your Measures to the Metrics Table

Metrics tables are great! I argue that all of you measures should be moved into a Metrics table. Don't know what a Metrics table is? Care to know why I think you should move all measures to that table? Please watch the video below and your questions will be answered. My reasons: Makes it easier … Continue reading PowerBI & DAX: Three Reasons to Move All Your Measures to the Metrics Table

# Power BI: Getting Better at DAX – Understanding SUMX()

SUMX() is one of my favorite functions, but it can be tricky to understand how it works some times. Hopefully, this video can help you understand this function a little better. https://youtu.be/dY9YniavqMA The points I make in the video: Normally, in DAX we cannot do math using column names for additions and multiplications, however, when … Continue reading Power BI: Getting Better at DAX – Understanding SUMX()

# Power BI Custom Visual Review: Simple Waterfall (can Microsoft hold its own???)

If you have a short attention span, then then I will have some mercy on you and just give you the answer – NO. If you are reading still and are genuinely curious about why, then please keep reading. I am looking at the following criteria in my evaluation: How intuitive the visual is How … Continue reading Power BI Custom Visual Review: Simple Waterfall (can Microsoft hold its own???)

# CloudScope Ends Support for Power BI Custom Visuals

In this troubling news, CloudScope just announced that it is ending its support for Power BI Custom Visuals. CloudScope was an early adopter of the Power BI platform and you used to be able to see many custom visuals from the company that extended the very limited set of visuals that Microsoft provides in Power … Continue reading CloudScope Ends Support for Power BI Custom Visuals