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
- New article: Power BI Bookmarks https://t.co/1drRJYhVEJ
9 days ago
- this is great! #PowerBI conditional formatting https://t.co/oW4i3MBxNf
16 days ago
- @EscobarMiguel90 @MSPowerBI GitHub newbie here too - sad, the two of us trying to share - I have forked your code a… https://t.co/azN06jaTza
20 days ago
Subscribe to our NewsletterDon’t miss updates!
Want to take a look? » Last Update
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
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