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
Subscribe to our NewsletterDon’t miss updates!
Want to take a look? » Last Update
I am not sure how I missed the ability to copy Power Queries and/or Folders between PBIX files in Power BI. Most users are aware of the template capabilities of Power BI - you can create a Power BI model, export the model as a template, and use the template for new solutions. In some scenarios, that template has too many queries, sources, etc. and you have to remove quite a bit to get a usable model. If you have been in a situation where you only want a subset of the queries or have a single query that you reuse
Power BI bookmarks add so much valuable functionality to the application. They allow so many capabilities that were missing prior. Some are true workarounds but some are on par with other BI tools. Take MicroStrategy and their use of panes - historically difficult to work with - with Bookmarks and the Selection Pane, it is very easy to duplicate this capability in Power BI. This allows you to change visuals dynamically - or make it look like you are dynamically changing the axis by using bookmarks, the selection pane, buttons/tabs, and either multiple visuals or drill down levels to change
Where do people find the time to blog? I am envious and appreciative at the same time. Blogging takes time, initiative, dedication, and a desire to share. Starting a website for your consulting practice is fairly standard. Blogging allows you to show your knowledge about the topic but also to bring potential clients to your site, build a reputation and credibility, etc. When I started blogging, I had high hopes (too high). I wanted to write about topics that were overlooked or provide more detail on topics that were skimmed over, etc. During that time, the continued growth of Power BI as
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