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
- RT @marcorus: Welcome to https://t.co/zTauiQb7Xe!
You can write and run DAX queries over a sample Contoso database using a web page: no se…
64 days ago - this is great! ETL run completes and need to kick off your #PowerBI dataflow? Need to initiate your dataset refresh… https://t.co/VYX7rnzcIA
122 days ago - Oh boy! DirectQuery Power BI models = composite models (import Excel alongside Power BI model or composite model us… https://t.co/JIHmaVyDHJ
126 days ago
Recent Articles
-
Why I started vizbp…..
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
-
One Bite Pizza Power BI Analysis
One Bite, Everybody Knows The Rules. It was time for a bit of a fun review. I decided to create a more fun reporting solution this time. If you haven't watched One Bite pizza reviews from Barstool Sports, you should. It is a funny critique on a venue's pizza primarily around New York but also wherever Dave travels. It also includes reviews from the community. From their site: Find the best slice of pizza using the One Bite app from Barstool Sports. Starting as a video series, Dave “El Presidente” Portnoy has created a cult following of people giving “one bite” pizza reviews by
How to analyze Power BI Usage across workspaces
Workarounds.....workarounds.....workarounds. We all build workarounds as necessary until more enterprise-ready functionality is made available. This is true for Power BI Usage metrics across workspaces. We have usage models for each individual workspace but there are several issues with them. you have to copy the model in order to edit it and make it usefulyou are unable to share this model with non-admins or non-members of the workspace (why? - business owners want to see who is using the report, how often, etc.)you have to make this modification in each and every workspace you want to measure usage againstyou are unable
Infor Syteline Reports in Power BI
In working with applications and ERP systems, you will find they are lacking in in-depth analysis and reporting. There comes a time where you realize there is a need for external reporting to augment the standard reporting. This is how the Infor Syteline Reports in Power BI came about. In one of my previous roles and past consulting engagements, I built these Syteline reports in Power BI for: Analyzing the general ledger dataAdding insight into estimates, orders, jobs, job hours, shipping/receiving, rma(s), order references, and customer/item/vendor addition.Providing extra insight into daily sales and invoicing activity These came out of genuine
-
How to compare Power BI Models
Want to compare models to document improvement? Want to compare your DEV/QA model with your model in PRODUCTION? Want to know the model size improvement of modifications made to a model? The ability to compare and analyze models, table, column sizing, and relationships allows you to show the improvements made to a model via optimization techniques. Enter the Power BI Model Comparison solution @ vizbp. 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
PowerApps Report Survey to collect user feedback
Need to collect end user feedback on a reporting solution? The ability to create a simple, unobstructed feedback loop is critical to end user adoption and usability of your reporting environment. This is a very simple PowerApps solution built on the PowerApps Employee Engagement Survey Example. It collects critical information on the completeness of data, visuals, speed, overall score, and comments about a specific Power BI or reporting solution. It is made to be embedded in a Power BI report in order to easily collect the information from consumers while they are accessing the report directly. Take a look at the product and