Using Monkey Tools - No-code Creation of Basic Explicit Measures!

If there is one thing I try to convince my DAX trainees, it is to built explicit measures over implicit measures. From default formatting to honored names and reusability, there are just so many advantages. But what if you're newer to the DAX language and don't know how to write your DAX? Or you wonder about which options you have for a specific field? Our Basic Explicit Measure Monkey has you covered!

The goal of this monkey is to help you write an explicit measure for simple aggregation that works. It's much smarter than allowing you to create just a SUM or a COUNT - in fact it looks at the data in your column and presents you with only functions that make sense! There will be no accidental SUMing of dates, or Standard Deviations of product names as our Monkeys identify that those aggregations just don't make sense.

You pick the column to aggregate. You pick from a smart list of valid aggregation types. Our Monkey writes the DAX. The monkey even suggests a name, where to store the measure and the default formatting (each of which you can change if needed.) It really is just that simple - the way measure creation SHOULD be!