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
- Looking for a #PowerBI or #businessintelligence job? Take a real world suggestion here - it fits for any business i… https://t.co/I1zuG3GGvz
- #PowerBI Data Dictionary - available
Document your Power BI Premium environment - uses Power BI API conn… https://t.co/SuC3KguC4h
4 days ago
- @JustynaLucznik 1. right click include/exclude
3. drag segmentation to change order of tree
4. easier click on the +
6 days ago
Subscribe to our Newsletter
[wysija_form id=”1″]Don’t miss updates!
Want to take a look? » Last Update
Visualization Blueprints - vizbp - is the first marketplace built for reporting and data analysis. Jumpstart your reporting projects with ready-to-use, proven reporting templates/solutions from creators around the world.https://www.vizbp.com I am a hustler. All (most) consultants are in one way or another. You have to be to find consistent work. But, my mind is always thinking of other ways to make money and provide something valuable to others. What can I do or make to make things easier for others. In my career, I have implemented or been involved in so many different software initiatives where the application or reporting
This blog will start off with a word (or a lot of words) of advice for job seekers looking for a new Power BI development position. Bring Power BI examples. DO NOT come empty-handed and explain that you cannot show your prior work because it was confidential data. There are plenty of free data sources that you can get your hands on, show that you have initiative, and show that you fine tune your craft outside of the assigned projects you have worked on. I am not going to list all of the free data sources available for building sample data
Whether you want to analyze an individual workspace or your full Power BI environment (all workspaces and solutions you are an admin of), you will find the Power BI Data Dictionary solution invaluable. YOU DO NOT HAVE TO BE AN ADMIN with this product - just an admin of the Premium workspaces you want to analyze! Premium is required currently until XMLA connectivity is opened up to non-premium workspaces. The only other requirement is for the models to be documented - for the developers to enter table, column, and measure definitions when creating the model. Unfortunately, there is not much documentation
Whether you want to analyze your personal "My Workspace" environment, your gateways, or all workspaces and solutions you are an admin of, you will find the Power BI Workspace Metrics solution invaluable. YOU DO NOT HAVE TO BE AN ADMIN with this product - just an admin of the workspaces you want to analyze! Until now, the Power BI Capacity Metrics solution was the only real solution provided for this functionality but it is only available for Premium environments. What do you do if you want to document or analyze your solutions in non-Premium environments? You would have to develop
Whether you want to analyze an individual solution or your full Power BI environment (all workspaces and solutions you are an admin of), you will find the Power BI Model Analyzer solution invaluable. YOU DO NOT HAVE TO BE AN ADMIN with this product - just an admin of the Premium workspaces you want to analyze! Premium is required currently until XMLA connectivity is opened up to non-premium workspaces. There are other solutions available for this functionality but most are only available for single models (I will reference these at the end of the post). What do you do if you want