PowerDAX

PowerDAX & Data Analysis Expressions (DAX)

is the native query and formula language for Microsoft PowerPivot data models, Power BI data models, and SQL Server Analysis Services Tabular models. DAX includes some of the familiar Excel functions that you have frequently utilized in Excel formulas, but also includes additional functions designed to manipulate relational data as needed. Much is still to be discovered about DAX but PowerDAX will provide best practices and real-world examples for you to utilize and possibly improve upon. What is known is that it is powerful!

PowerDAX will provide information on Microsoft Business Intelligence components including Excel, Power BI, Power View, Power Query, Power Map, SSAS Tabular and more.  Check back often, provide input, and subscribe to PowerDAX to stay up to date!

Follow Us on Twitter

  • @notaboutthecell @dataveld it should apply to clearing filters in the pane as well as selecting them though
  • @dataveld "apply all" for query reduction - optimization is key
  • @HavensBI one note - the apply button does not apply to clearing filters in the filter pane - would be nice @MSPowerBI

Recent Articles