Navigating DAX Function Types: A list of DAX Scalar and Table functions
Over my years of DAX experience, I’ve frequently wished that Microsoft’s DAX Reference listed the output type for each function, but since it has yet to happen I decided to create this myself. I’m lucky to work with an amazing team of consultants here at P3, and I’ll build upon the great work that Mat Herring has done with his “Great Function Project.”
Let’s start with a review of table vs. scalar functions and when to use them.