How To Solve a Complex DAX Problem-Level: Advanced I was helping someone on Power Pivot Forum last week with a tricky calculated column question. As an aside, you may know that I always advise beginners to keep away from calculated columns. You mostly don’t need calculated columns because in most circumstances a measure is a better option to use (read more […]Read More
Cumulative Running Total Based on Highest Value-Level: Advanced I’ve helped a couple of people out on various forums on this topic over the last week, and that is normally a good sign that I need a blog post on the topic. The scenario is to create a Pareto cumulative running total based on the top products, customers or whatever. This is a bit […]Read More
Many to Many Relationships in DAX Explained-Level: Advanced (Level: Advanced, but explained in detail so everyone can understand) There is a lot to learn in DAX if you want to be a ninja. A couple of the more complex and important things to learn and understand are filter propagation and context transition. It is not so much that you need to be […]Read More
Bring your data to life - Let's discuss how Matt can help!