The Hidden DAX Trap In Power BI

For today’s video, I’d like to focus on something I refer to as the “Hidden DAX Trap.” This is a common situation but if you encounter it without warning, it can be a major headache. Your data model and DAX will look right, but not produce the correct results. I will walk through how to recognize and avoid this trap, and in the process highlight a key DAX best practice. If you want to further explore/experiment with the scenario I discuss in the video, you can download the PBIX file from the Enterprise DNA forum: Brian ***** Video Details ***** 00:00 Introduction 00:43 The data model 01:13 Case #1: Total per year 02:26 Case #2: Total per quarter 03:07 Case #3: Total in month & year 07:35 Matrix presentation ***** Learning Power BI? ***** FREE COURSE - Ultimate Beginners Guide To Power BI - FREE COURSE - Ultimate Beginners Guide To DAX -