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)

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

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

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()