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
- #PowerBI + #PowerAutomate (#MSFlow) product to check the data sources on your on-premises data gateway and notify g… https://t.co/bx109aza41
21 hours ago
- New #PowerBI report templates for #Infor #CloudSuiteIndustrial #SyteLine released @vizbp:
21 hours ago
- Why you need a #PowerBI report template....relevant for any reporting application.
11 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
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
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
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
Need to trigger a refresh on a Power BI solution? Want to trigger a refresh based on a completed ETL run or when a file is created in a SharePoint directory? Want to notify the dataset owner when the refresh begins, when it completes successfully, or only when the refresh fails? The ability to trigger a refresh not based on a schedule but on a variable trigger and notify the owner of the dataset if the refresh fails is critical to an optimized environment and environment oversight. There is a new Microsoft Automate (Microsoft Flow) action to refresh a Power BI
Need to be notified when your Power BI Gateway Datasource loses connectivity? The ability to identify connectivity issues before your end users or sponsors is critical to end user adoption in your Power BI environment. This solution will be updated periodically as new feature requests and other thoughts on what could be added to improve the solution. Make sure you’re running the latest version. The report will have a version displayed and notify you if there is a new version available. The Power BI + Power Automate Gateway Status solution utilizes the free Power BI API + Power Automate Custom Connector. Based on