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!
Subscribe to our NewsletterDon’t miss updates!
Want to take a look? » Last Update
The top SQL Server Analysis Services 2014-2016 Enhancements If you are like most businesses, you have not yet upgraded to SQL 2014. We are just now moving to SQL 2014 as a standard. As a
Using a card as a slicer in Power BI is a common question I receive. The quick answer is it is not possible - I hear this much too often from others. However, that is a very rare statement I would make about Power BI. It is a rare statement that I use with anything data related. I feel like so much more is possible if you think outside of the box. Too many people stop when they cannot find the answer they were looking for. I will add a quick posting to show a couple of options on how to
Power BI Dashboard Filters sometimes cause confusion. In one of my many communication channels, there was a question posed related to the ability to add Power BI dashboard filters in order to filter Power BI dashboard tiles. There is some confusion at times and I would like to make a short article to clear some of them up if possible. 1 - Tiles pinned to a dashboard are displayed based on the filters applied to them via the filter pane OR via slicers OR via cross filtering at the time of pinning. For example, I have a report that is currently unfiltered. I pin the top
Power BI Training? My most common request, by far, is for training resources for Power BI. There have been some posts I have used to acquire more/better/different options for learning Power BI but I have accumulated, filtered out, and singled out the best resources below. I will add/modify periodically as new resources are added and if any of these sources become stale. Power BI Guided Learning http://bit.ly/2dcMhRc "Start your learning journey through Power BI with this sequenced collection of courses, and understand the extensive and powerful capabilities of Power BI." Great Power BI training resource - always kept up to date. Microsoft YouTube Training Curriculum http://bit.ly/2es4nnb Full Microsoft provided training
I wanted to make a quick posting on my (still-ongoing) attempt to push Power BI Services to my large organization but having to deal with my organization's apprehension to the cloud and desire to have Power BI On-Premises. * Note: I will update when I have more information on the options below. There are tons of large organizations (and I would dare say medium and small organizations) that have this apprehension. The cloud! Look what happened with celebrity photos on iCloud and the data breaches that occur with major credit cards so often! What are the options? 1. Wait (w/ Questions) According to the Microsoft road